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.
-
Worked perfectly, THANK YOU!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!