-
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.
-
Formula to add additional year or years to a date referencing another column in the Grid
We have about 17 different training activities that we track for each employee. Upon completion of the training we enter the certification date for that type of training. Most of these certification expire after1 year, 3 years, or never (one time certification). I'd like to be able to use a formula to add either 1 year, 3…
-
why can I not edit formulas on my tablet even though my samsung tablet is in desktop mode?
I want to be able to access and work from my tablet with smartsheet... However a lot of my work includes formulas & metrics ... I cannot seem to create formulas when using my tablet even when my tablet is in desktop mode and going through the smartsheet web version... This really lets smartsheet down :(