Forum Discussion
GauravSharma3
8 years agoQrew Commander
What are you asking? How to apply these rules or what is the best way to apply the above conditions?
ReginaTan
8 years agoQrew Trainee
i saw this formula but i'm not sure if it is right.
IF(([Status]="Completed"),[End Date]-[Start Date],Today()- [Start Date])
I need to know how to change "[End Date]-[Start Date],Today()- [Start Date])" to something that allows me to pick a particular date instead of a standard date formula. Is that possible?
IF(([Status]="Completed"),[End Date]-[Start Date],Today()- [Start Date])
I need to know how to change "[End Date]-[Start Date],Today()- [Start Date])" to something that allows me to pick a particular date instead of a standard date formula. Is that possible?