-
Flag columns and formulas?
Hi, I would like to use a Flag column with the following workflow: Manually enable the flag. Automation then sends an approval request once date is reached (in separate column). I would then like to have the flag clear when the "Approval Request" column gets an "Approved" response back from the automated approval request.…
-
Remove Extra Commas in Join/Collect?
I have a great formula of JOIN and COLLECT together that pulls info from 11 columns. It pulls strings if they meet certain conditions with commas as a delimiter. But if the conditions are not met, I have a bunch of commas next to each other. E.g. , , , EX1, , EX4, , , , and in some cases, just 11 commas. Is there a way to…
-
Date Columns formula
Hello! I'm new to Smartsheet so I'm hoping you all could help me. I have three date columns and a duration (how many days between the dates) column. ColumnA - Initial baseline date ColumnB - Current EST Date ColumnC - Actual Date. Column D - Duration What I'm wondering is if there's a formula that will enable me to be able…
-
Package condition vlookup
Hi, I'm trying to help our loading dock out by taking the cells they would normally just fill out, make it a form that is submitted per package. At the end of the day, look at the summary and send an email to the recipient based on the storage condition. The three storage conditions are 4C, -20C, and -80C, on a connected…
-
Issues with autosaving data
It appears that items are not saving or following the one minute save rule. These issues have occurred in date range cells as well as check box cells. My thought is that this could be linked to a iOS 14 beta issue. At this time, I have only noticed this occurrence with absolute certainty twice. Here is the current software…
-
Trying to do a SUMIF formula - Help!
I've been trying all kinds of formulas and can't get this to work right. I'm trying to do a formula with the below that says IF Approved? column = "Yes" then SUM the range of cells (CSM PM + DEV / BA + Arch/Engin + UIUX +QA)
-
Is it possible to divide the result of a countif formula by another?
I am trying to create sheet summary data that returns the % complete we are on confirming attendees at a new event. In a check box column I have the formula "=COUNTIF([Confirmed - New Dates]3:[Confirmed - New Dates]47, 1) +" which returns the correct value. Then in another check box column I have the total amount of people…
-
Creating an average based on 3 different sheets
I'm trying to create an average based on 3 different sheets. Right now I have 3 sheets (Tracker, Completed, Dead) these all have a summary calculation to give me the total number of sites for each developer. I'm trying to create a number for each developer that tell me how many sites get completed on average. Right now I…
-
New row autofill
I want to autofill new rows with formulas that would execute as data is loaded into certain fields. Specifically, someone uses a form to start a new row. In the form there is a logic option but not a real conditional with a formula. It may not be available in the Form but what about the Sheet? There is languaging about two…
-
Notification Exclusion
Hello, I am the owner and creator of a smartsheet, but a co-worker is the main user of the sheet, though others contribute. I have setup an automated workflow so that she is notified whenever a row is added or changed, but she doesn't need a notification if she is the one making a change. Am I missing a way to do this in…