-
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 :(
-
How do I count the number of times a "Staff Person" selected a dropdown option?
In my original sheet there is a form staff can fill out to request passes. I'd like to count the number of time each staff person requested a pass and what pass they requested. In my metrics sheet the "Staff Name" column has all the names and the other columns would hopefully be where number of "Parking Pass"es the staff…
-
Workdays Counter
Looking for help with the below formula. It countdowns the workdays from the start of the promotion to the completion date. The problem is once it goes past the completion date it starts counting backward. I would like it to stop counting once the completion date is hit. Thank you for any assistance.
-
How to list values in a cell based on another cell with distinct names (in a list format too)
Hi, We are trying to present the labor hours workers have dedicated to one same task on different instances. We started by nesting =JOIN(DISTINCT(COLLECT({Worker}, {Task}, "DC6-" + [Task Label]@row), ", "), ", ") We have successfully filtered a list of workers that have dedicated hours to a task. We would then want to…
