Quick Formula Help
Hi Community,
I'm working with a colleague to create a column formula with multiple IF conditions. Just struggling to get our initial chain going before adding in others.
What we need:
-We have a column entitled "Submission Type" that contains a dropdown list of different submissions. Each submission has an estimated timeline for an "Approval Date" based on its type.
-We have a column entitled "Document Approval" that contains a manual date our teams are entering for the completion of our individual submissions.
-We have a column entitled "Calculated Submission Date", in which we would need to use the previous bullets to determine our date in that column.
For example, If our submission type is Annual Report that has a predetermined 3 day timeline, we want to have a formula that calculates our Document Approval date +3, nothing needed otherwise in the cell. Below is my example, but I'm unsure why it is giving me an error.
Thanks in advance!
Answers
-
Hi @jsilverio
Hope you are fine, for your example in your post please try the following formula:
Calculated Submission Date =IFERROR(IF([Submission Type]@row = "Annual Report", [Document Approval]@row + 3), "")
please note that "Document Approval" & "Calculated Submission Date" are Date type columns.
the following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!