Need Help, Nested If Date formula
I am trying to streamline a sheet that is used for project payment forecasting. The goal is to use the project's estimated ship date, when 40% of the project total is due, and have the 40% amount cell be copied into the corresponding date columns. I have a column for each month going to the end of the year. The sheet is a bit cluttered but I use reports to organize data in a neater way.
what I am trying to accomplish is, if the [ESTIMATED SHIP DATE] cell is not blank & is a date, then take [INVOICED AMOUNT] from the same row and copy it into the correct month column.
Best Answer
-
Worked perfectly, THANK YOU!
Answers
-
Hi @Pnda
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Have a fantastic week & Happy Independence Day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for the info @Andrée Starå.
I dont think the automation will work for my application because I need the [Row Total] value to go into the correct date column based on the [Est Project Ship Date]
in the screen grab below you can see the ROW Total, Est Ship date, I would like help writing a formula to copy the row total into the corresponding month columns to the left of the EST SHIP column based on the date in the EST SHIP DATE column for each row
-
All you need is an IF formula that you would tweak for each month.
=IF(IFERROR(MONTH([EST SHIP DATE]@row), 0) = 1, [ROW TOTAL]@row)
The above would go in the January column. Changing the 1 to a 2 will update it for February. 3 would be for March, so on and so forth.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Worked perfectly, THANK YOU!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!