Priorities based on end date

siofra.keane98086

Hi I was hoping someone could help me with this, I'm new to Smartsheet and not overly familiar with IF statements. I was wondering if there's a way to automate by priorities based on my end date. For example if the end date is within 2 weeks, priority is high, within the month, priority is medium and at any other time tasks are low priority. 

Paul Newcome

Yes. You would want to use a nested IF statement. You will need to replace the "specific text" in the quotes with the actual text in reference to the exact symbols you are using, but it would end up looking something like this...

 

=IF([End Date]@row <= TODAY(14), "High", IF([End Date]@row <= TODAY(30), "Medium", "Low"))

siofra.keane98086

That didn't quite work, its not confining the days with the 14 days, so a high priority is being applied to everything in the past. Medium priority is being applied to the tasks in the coming month and low being applied to tasks in the future. It may just be the start of that IF statement causing issues

 

Paul Newcome

My apologies. I didn't realize you were wanting to exclude past dates.

 

Try this...

 

=IF(AND([End Date]@row <= TODAY(14), [End Date]@row > TODAY()), "High", IF([End Date]@row <= TODAY(30), "Medium", "Low"))

siofra.keane98086

Thank You!