-
IF Formula Help
Hi, I have a column labeled 'Flag' that uses the formula =IF([Calculated Total]@row < [Total Dollars on Invoice]@row, "FLAG", " ") that either is showing as blank for all rows or if I flip it shows as 'FLAG' for all rows. The 'calculated total' column is a sum of several other columns and the Total Dollars column is just…
-
Automated Notifications - Alert Someone "Send to contacts in a cell"
Hello, I have a sheet that has a column for email addresses. I want to created an automation that will send info from the sheet to the to the email that is on the same row where the new info are added. When I create the notification under "alert someone" the option "send to contacts in a cell" doesnt populate any of the…
-
Using Successors as a workaround for not having direct access to Row number
I'm giving Smartsheets and 2nd shot. Have been happy with use as a staff task tracker for last year and working on building a full project management system. I have used Predecessors to control status of next task unfortunately I have to manually enter a Task ID for all tasks matching the current row number as we still…
-
Multi-Step Workflow: Creating and Linking Forms with Unique Identifiers
Good morning! I'm trying the following in Smartsheet: 1. Create a form that has a field to input multiple emails, each submission has a Unique ID. 2. When the form gets submitted, it will send an email to the emails in the submition with a new form of a different sheet. 3. Once the second form is filled by the email…
-
Sheet Summary Formula with Indent Data
Trying to create a sheet summary formula to calculate the cost/project of indent data based on the outdented criteria: So if the Regions size is Large then calculate the cost/project for all regions, I've only shown 2 as an example but this encompasses 80 regions of sizes 1-5 with multiple project names. the count of…
-
Date In IF Statements
Hello, I have a data set that includes some dates ranges, and based on those dates ranges we want to identify different situations. Examples of these are: Update #1 AND Update #2 happens on or before X date, then flag as "Situation A" Update #1 happens on or before X date AND Update #2 happens on or after Y date, then flag…
-
Convert Cell Formula to Column Unavailable
Hi, I want to convert this formula to a column formula, but it's greyed out and won't let me. =[Baseline Duration]@row - Duration@row I'm trying to get a duration variance in my schedule. Both columns are type Duration. The formula seems to work fine in the cell. Thanks!
-
Contact Formula from Latest Comment Column
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment. I currently can move (1) email but not multiple ones. I then put it in a helper…
-
Formula to set RYG Status from a Cell with a drop down list?
I have a PO Status Column that I want to display a Red, Green, Or Yellow ball dependent on a selected drop down list in separate column titles Procurement Status. The formula Im using is below but it keeps returning "Unparseable". =IF([Procurement Status]@row="Awarded", Green) IF([Procurement Status]@row="In Quote",…
-
Pulling Latest Date Data From another sheet
Hello all, I'm trying to have one sheet pull the latest Date from another sheet, where a specific name is in the Name column. This is the formula I can't get to work. It receives a #unparsable error. =INDEX('Sheet Name'!Date, MATCH(MAXIFS('Sheet Name'!Date, 'Sheet Name'!Name, "Employee Name"), 'Sheet Name'!Date, 0)) I have…