-
Calculating Next Monday, Wednesday, Friday
I'm trying to write a formula to calculate the next monday, wednesday, and friday following a particular date. The AI formula generated =IF(ISDATE([Start Date]@row), [Start Date]@row + (8 - WEEKDAY([Start Date]@row, 2)), "") using the example above; however, it generated an #INCORRECT ARGUMENT error. The expected results…
-
How if a box is checked it any point in the process it will mark it checked for that section
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This will stop the notification for that particular item. I do not want it to check the boxes for the whole column because it will…
-
Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…
-
Updating cells to Formulas
I have a sheet that we track miles for vehicles for services so 1 column is for a A the next B service. those columns set of formatting against currant mileage and let the mechanic know if a service is due. the issue we have is the A is every 18K miles the B is 36K miles. When a B service gets done it resets the A service…
-
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
-
FIX Required: Last Modified Date + TODAY Function = updates all rows
Hello Smartsheet community I would like to see a fix. When you use the "TODAY" function anywhere in your sheet, ANY changes will update the "last modified date" for all rows. What I want: Only update the individual row that has changed. Why? So I know when (and who) made the last change. This was verified as a problem by…
-
Help on formula: count if with multiple criteria
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation",…
-
Calculating Averages with Different Columns
Hi - I am trying to calculate average based on different columns, example… Sandra A - TTL Seconds + Kelly B - TTL Seconds + Meri - TTL Seconds + Coen - TTL Seconds = Average of those numbers for each row Does anyone know the formula to do that?
-
If statements with currency positive and negative and needing value
I'm having to try to create several formulas so that I can in turn create triggers. I need to say if there is a value in cell A with a difference of $1 (positive or negative) from cell A and cell B I want it to say notify, if not say no. Anyone have a suggestion. I had =IF([Cash Distribution (AM)]@row - [Received Cash…
-
Allow viewing of Formulas on View only or Locked Shared Sheets
It would be great to be able to right click on a cell and "copy formula" or "Show formula" so that it could be copied, for viewable sheets. Or, create a sharing method that allows viewing of formulas. This is mainly for sheets that community users share as solutions to questions. It would allow us to actually see the…
