Sign in to join the conversation:
I am trying automate pulling data entered in the form, that pulls into the sheet to then pull into a sight without using a report as the formatting is not very good, can anyone help?]
I have attached a screen shot to support above.
Thanks
Harris,
See if this helps:
http://ronin-global.com/2017/01/09/smartsheet-referencing-a-cell-that-doesnt-exist-yet/
Craig
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
