Hi, I am trying to figure out how to do the following and I am new to Monday. This would sure make me look great!
Basically we report against how much revenue we recognize based on how many days a project has been open. If the project has been open less than 90 days, then the stage the project is in dictates how much revenue we have recognized. See below:
Questionnaire - 30% complete
Design - 60% complete
Development - 80% complete
Sandbox - 90% complete
Complete - 100% complete
If the project has been open for more than 90 days, the number of days the project has been open then dictates the amount of revenue we have recognized. See below:
0-90 days - Use % above
90 - 120 days - Automatically 75% complete
120-180 days - Automatically 90% complete
180 days - Automatically 100% complete
We use a project purchased date column for reference.
Then we have a status column which reflects the first group of statuses above.
I want to update a different column’s status, based on how much revenue we have recognized with the above logic.
I am thinking The first thing I need to do is count the days. I have learned to do that using:
I would imagine I would then check to see using an IF statement whether or not the returned value is less than 90 and then and ANDIF statement to see what range the number of days past the purchase date falls in by multiple and if statements, but I really just don’t know.