-
How to get an "Average" of statuses
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, each of the projects has a status - not started, in progress and complete. I am trying to find a formula where out of these…
-
SUM IF Formula
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 and can't workout what the issue is! TIA Cheryl
-
Formula to copy contents of a sheet to another
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 that I could achieve this using the index collect function, however the data I am trying to call goes in hundreds of rows. Any…
-
IF Function to multiply 2 numbers if the value of a column is greater than 1.99
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 greater. Can anybody help with this please?
-
I need a formula that allows the following
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.
-
IF statement formula help
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 how to add the second layer. Thank you for your help!
-
Trying to ignore the error cells and calculate average for the column
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 someone can help out!
-
COUNTIFS with OR
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 Meeting" appear in my column 'Type'. This formula isn't working: =COUNTIFS(Type:Type, "Action", OR (@cell = "Forthcoming…
-
INDEX MATCH MATCH
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(MATCH([Client Name]@row, MATCH([Assigned To Role]@row, {Timeline Team Assignment}, 0))) My Timeline has a bunch of tasks…
-
Formula to calculate End Date and Time based on Start Date, Time and Task duration
Hello, I'm looking for a formula to calculate the End Date and Time (MM/DD/YYYY)( HH:MM AM/PM) based on the Start Date and Start Time entered on a form using the Task standard routing time.
