Sumif assistance needed
Hello,
I think it's a sum if formula I need....
If the source column says "external review" and another column called Significance says "Major" I want to return a date of +60 days to the date within column Closed date.
Tags:
Answers
-
@Black_Raven_2020 You just need an IF formula. are these separate sheets or 1 sheet? Here is a quick stab at it with the info you have and the assumption of 1 sheet.
=IF(AND([Source Column]@row = "external review", Significance@row = "Major"), [Closed Date]@row + 60, "")
-
Thanks for your help Eric! Unfortunately nothing appears...not even a error code. I'm still working away at it!
-
Post a screen shot or check your spelling.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!