-
Having an Issue where I am doing a duplication check and what to email the duplicator email back
Hi, I need help figuring out a method to emailing a set of duplicate emails once. I have an intake for that records emails. If there are duplicate emails in the list of emails, I would want to email them back to tell them that they just submitted a duplicate email. However, The way i have set it up now, sends the same…
-
Text to populate when Box is Checked
I need to populate text in a cell when there is a box checked anywhere within a row. This is what I came up with, but it isn't working =IF([Weekend Travel:WeekendTravel]@row = 1, "Weekend Stay")
-
Concatenate Formula in SmartSheet
I am in the process of migrating workbooks from Excel to SmartSheet, but am having trouble with the Concatenate formula. I have a column of store numbers and am trying to automatically create the store manager email to be used across different sheets, but I cannot use the concatenate formula in SmartSheet the same way as…
-
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…
-
Count If formula using cross sheet reference
I've inherited a massive sheet and leadership has asked that it not be modified. There are 5 "actions" per row. I'm trying to count if any of the 5 actions are classified as "high" significance. The goal is to chart the number of "high" actions by function. =COUNTIFS({DD Input sheet - system team function}, "franchise",…
-
How to COUNTIF with multiple criteria and cross-sheet references
I am trying to create a COUNTIFS formula to count the number of times a book title appears in a range from another sheet AND if a checkbox is checked (also from that other sheet). The cells with the book titles contain multiple titles so I've been using a CONTAINS formula to match for each book title. I can get both…
-
Leave cell blank
Can someone help me update both of these formulas to leave the cell blank if the total is 0? Thanks =SUMIFS({Award Total}, {Grantor}, Grantor@row , {FY Awarded}, [FY22]@row , {Status}, HAS(@cell , "Awarded"), {Funding Source}, HAS(@cell , "Federal")) =SUM([FY22 Total]@row , [FY23 Total]@row , [FY24 Total]@row , [FY25…
-
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").…
-
Formulas for calculating total time
Hey everyone, I am newer to Smartsheet and I am making a form from previous data to continue time tracking. I am trying to get the sheet to add all the hours together from one day to make a total time. It would also be specific to each individual. Each person should be working 8 hours so I should be able to get a running…