-
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…
-
Formula Help
I am seeking assistance with a specific formula. I am creating an employee snow deactivation request and tracker. Employees can schedule time off during winter operations. The issue is that we have two periods, Preseson and In-Season. The Preseason period to submit your vacation is 7/15/25 thru 8/15/25 and In-Season is…
-
Multiply fields with formulas
I have 2 cells that I would like to take the output of the formula in each cell and multiple. I did the standard formula in the Pay cell but I am guessing due to my formulas in the other cells is causing an issue. Pay rate formula: =IF([Client Name]@row = "Weekend Stay", "$150") Total Hours formula: =COUNTIFS([Saturday…
-
Join text based on multiple conditions
Hello all, I need to Join the content of a Task column into one main cell in another column "Description". The conditions are: IF [Task] at row CONTAINS "Action Item" and Summary Field is unchecked than JOIN all the text separated by a comma (or even better assign a number to each of the tasks that contain "Action Item").…
-
COUNTIFS Using And as well as Or
Hello everyone, I am looking to have an information sheet that is looking for several criteria with "and" and "or". For example, I want the formula to count if the other sheet has "Priority 1" and "John Doe" and a status of either 1 or 2 or 3. I will have another cell on the information sheet for "Priority 2" and "John…
-
Need to Sum Multiple Column Check Boxes
I am trying to sum 2 different column's checkboxes and put that number into a different cell. I have tried a bunch of different ways and nothing seems to work. Below is one variation that I have tried and can't get it to work: =COUNTIF(AND[Saturday Stay:Saturday Stay] = 1, AND[Sunday Stay:Sunday Stay]=1)
-
Text in cell to translate to Number if different cell
I am trying to write a formula that when Client Name says Weekend Stay to populate $150 in the Rate of Pay column.
-
Automated emails based on cell values
I am trying to decide what the best way to set up an automated weekly email would be based on the image below. Basically, I want to send something out weekly based on the column items that are not meeting a certain set par level. For example the weekly list should include all items with '0' and exclude items that greater…
-
Using the Greater/Lesser than with %'s
I'm trying to build a formula for 3 separate columns where it generates a number on whether the % provided is below or above a certain threshold: Unauthorized Return Rates < 0.5% Administrative Return Rates < 3.0% In my current formula it should say if the % is greater than 0.5%, it should list "1", and if less than 0.5%…
-
Trying to combine 2 AND functions with an OR
Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND the version is less than 9 OR If the model is 2 AND the version is less that 18…