-
Alerts for max rows
Background: Shift information is typed into a main sheet in multiple columns/rows by multiple people, then at the end of the shift, the manager confirms the date, shift number, and shift information before checking a box that changes a value on each row, and triggers a couple copy to workflows. This is segmented into two…
-
Formula to calculate checkboxes per row?
I have a smartsheet that is currently used to track assignments to staff members. Data is input via a form, those rows are added to the bottom of sheet and I have columns with formulas that track how many assignments each person gets and of what "type". What I would like to do but haven't figured out how: each row has a…
-
Problem with automation and Auto-Number column ''Modified date''
Hi, I have a problem with automation vs Auto-Number column date. I created an automation to lock a row when column ''Commande ou soumission envoyée'' is checked. Problem is, when a add a check in one row, all the ''Modified date'' for all the row are updated. See below my automation and the result in yellow.
-
Right and Left Function for words within a cell
Hi, Any way to copy the 3rd word from the Right in [Address Column]@row? I have an Address column, I want to copy the City (3rd word from the end) into another column. [Address Column] Includes: Street, City, State (2 Values I.e. NY), Zip Code (all in 1 cell). Thank you!
-
SUMIFS based on date criteria
I am trying to add the sums of 3 different columns, with the criteria that the date of the rows being summed is created is greater than a certain day. The formula below has worked for summing just one column based on "Created Date" being greater than 11/10/2021, but when trying to add three columns I'm getting an #INVALID…
-
Formula Help, conditional formatting/If statement
I need a calculation to occur when criteria are met in another cell. For example, I want column D1 to reflect the following: if column A1 contains "Yes", I want the sheet to multiply column C1 by .10. If A1 contains, "No". I want either no action or a zero to be entered into D1. Any guidance would be appreciated!
-
Creating a custom number formula with conditions
Hello! I am trying to create a formula in which a row is automatically assigned the next number in a series if the progress column blank, "Not started," "Processing," or "Equipment checked out." If the progress column is something else ("Wait list," "Completed, Equipment returned," or "Completed, No response"), then no…
-
Remove the "0" in the column formula cell.
Help please! I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the last column meets the criteria, it shows a "0" for the first column. See formula in Screenshot and the cells…
-
INDEX(MATCH)?
I have two sheets. I would like to do a formula similar to index/match but I would like to pull in multiple strings. The index formula is =INDEX({Asset-DeviceSheet}, MATCH([Employee ID]@row, {eNumber-HPLStaffAssignedDevices}, 0), 0)
-
Automatic email notification
Can someone help me create an automation workflow that will send an automatic email to submitter when the status of request is se to Denied? Just to be noted I have a response to submitter column to where I input the message that needs to be send to the submitter. And also a Send Communication to Submitter column, a flag…