Hi, I need help for a simple formula. I emailed Smartsheet support a month ago but never got an answer.
I want to total how much has been spent by budget type in a given year. Example types are Gardening or Security. Debit is the $ amount, and Year is 2019 in this case.
Columns are: Type, Debit
0
hi,
i want to create a matrix with all the objectives of the different divisions to see if they are aligned or not to multiple strat plan objectives.
Should I have a seperate sheet of objectives for each division or have them all on the same sheet? Do I make a report to compare them? How can I do
0
I have two Nested IF formulas that work separately, but keep given me an "incorrect argument set" error when I combine them. The two formulas are:
=IF(OR([Current Status]1 = "Completed", [Current Status]1 = "Terminated"), "Blue", IF(AND(OR([Current Status]1 = "Planned", [Current Status]1 =
1
Hi, i have problems with Smartsheet Notifications email (smart tag).
At the moment in which an email notification is sent, configured from the Alerts and Actions section with smart tags.
0
I need to first find the column number where the number 1 resides on the "Lookup Value -->" row.
Next, I need to shift two columns to the right, which would be "4/2019 C" and sum the values for Client B,
I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I
0
Is there any functionality in SmartSheet that will let me (the SmartSheet Owner) see what an Update Request or an Alert actually looks like to the end users.
I understand I could send a TEST out to myself and see the Update Request as is happens but I make changes to these standard request often
0
Hello all,
I have been reading through the forum this morning on how to work around time duration in SS. I used the trusty Travis/Ajayi "formula from hell" to get an actual calculation! yeah!!!
My problem is.... trying to SUM the duration column. I have attached a screenshot. I usually use
0
We have an external group of grant committee members viewing a Smartsheet that we are hosting. Some of them do not have Dropbox. If we attach files from Dropbox, are they going to have difficulty opening
0
Good Afternoon,
I am new to Smartsheet, and am having trouble with what seems to be a simple task. The parent % complete will not change from 0%, no matter what I put in the child's information.
Thanks.
0
Hello everyone,
I am currently using this:
=IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red"))))
Which is working but I try to add this:
IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow"