This is my first time using the monday.com forum. Thank you all
So, I am creating an inventory tracking board and I want to have one column display the number of days an specific item has been on inventory.
I tought of two ways to do it but could not get neither to work.
- If status = “On Inventory” , Today() - Date Adquiered
- If Date adquiered = “”, Today() - date acquired, date aquiered - date sold
things along these lines with the right openings and closings.
If anyone got an idea how i can do this, I would greatly appreciate it