If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.
Hi team, I am trying to find the best formula to get an average of statuses. I have a helper sheet build out for this purpose. I have certain sub-goals and several projects tied to these sub-goals, ea…
Hi I am trying to sum the number of days based on a criteria - I'm expecting a 6 to come back but, instead I'm getting a 0 I know its something super simple but, I've been looking at this for ages now…
I’m new to smartsheet and am trying to figure out a way to call contents of a sheet to another based on certain criteria, something similar to what Filter function does in google sheets. I am aware th…
Hi So I have a current set up in smartsheet, i have the sheet to figure out total time between 2 times. Now I need to do that TOTAL TIME multiplied by No of days BUT Only when the "No of Days" is 2 or…
If the Created By is Blank then insert the Create By data in the New Created By Column but if Created By is Not Blank then insert the Created By data into the New Created By column.
Hi, I am trying to create a IF statement for the following. If submission-1 is "Complete" or "N/A" to reflect 7. Here is what I have so far =IF([Submissions- 1]@row = "complete", 7, 0) I'm not sure ho…
I've been trying to ignore the cells which have #invalid data type calculate the entire column with numbers. Please see attached. I've tried iferror as well with no luck!! Will highly appreciate if so…
Hi all I think this should be simple formula, but I just can't get it work. Any help would be gratefully received. I would like to count the times both possibilities of "Action" and "Forthcoming Meeti…
I'm trying to create a formula that looks up a row and column and pulls in the resulting detail. I've researched through Community and all the various documentation but can't get this to work. =INDEX(…