Looking for a formula that will auto increment number every day based on other cells assigned values


Essentially I am looking to count days and issue is open and assigned to our company.

I was able to somewhat achieve this using a second sheet but there is an administration overhead to this. Issues were copied to second sheet every night and then column in main sheet incremented the days with Team column based on current assigned Team and Status


=IF([Assigned Company]@row = "Our Company", IF([Summary Status]@row = "Open", 1, 0), 0) + +IFERROR(INDEX({OldIssues-DaysPP}, MATCH([Ref #]@row, {OldIssues-REF}, 0)), 0)

Any ideas on how to achieve in a single sheet?

Thanks in advance


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!