-
Apostrophe being inserted before Formula when using Smartsheet Forms
Hello, we have a Sheet setup with a Column which has the Formula =[Project]@row + " " + [Note]@row taking the info from the Project and Note columns. We also have a form for this sheet where you pick the Project and add a Note, what happens when we complete the form is a Leading Apostrophe is inserted in front of the…
-
change cell value to include {{column}} does not work same way as email workflow
I am using a Change Cell workflow to use the same feature of the email workflow of embedding {{column}} into the text. The same text that works in email workflow does not work in the change cell. In this example, if the Speed Limit Column is 100 and the Infringe Speed column is 121, the test that is produced should be…
-
Formula to return text rather than a number
Hi there, I have the following columns in use: Plan Expiry date (Date column) Date of Event (Date Column) Status of Plan (Text Column with Formula) I have used the following formula in the 'Status of Plan' column to let me know if a plan had expired when an event occurred. =IF(ISDATE([Plan Expiry Date]@row), [Date of…
-
CONTRACT EXPIRATION DATE
1-I am trying to reference another to provide results of contract expiration date - 2- I would like to display in a dashboard the percent of total contracts that has expidered, will expire in 1year, 6month, 90 days 30 days, 14 days and 7 days 3- finally if there was an extension, to input that date in a new column that…
-
Help with IF/AND formula for symbols
Hello! I am working on a formula to display red/yellow/green circles for project health, but I want to filter out projects that are closed. I have the formula working but when I try to add the AND part to filter out closed projects, I keep getting errors. Here's what I have: =IF(TODAY() = [Estimated Finish]@row, "Yellow",…
-
How do I update the Status from a date field column of another sheet
One sheet (sheet 1) a specific row contains a column/date field and I want to update a specific rows status field on another sheet (sheet 2) to status of Complete if a date is present in the source date field from Sheet 1.
-
Need Help with a "SumIfs" Formula
=SUMIFS({Budget}, {Project Type}, {Project Intake Range 1}, =Complete). The "Project Intake Range 1" is a column with "Not Started," "In Progress," "Complete". I want the sum if the "Project Intake Range 1" is "in Progress" or 'Not Started."
-
Count CHILDREN() and all children of children
So I am working on a formula to help me determine the health of a project based on the RYG balls and I want the project to count not only the children but all of the RGB balls of the children. So currently I am working on the formula for the top gray box. The formula I am currently using is the following:…
-
If/Then date question
Hi All, I'm trying to use the formula below to populate a cell with "late" if the Date Opened +30 days is greater than the Original Due Date. Is this possible? I'm very new to the formula side of SS so any help would be appreciated! Thanks! =IF([Date Opened]1 + 30, >[Original Due Date]@row, "late", "")
-
How do force a date to land on the following Monday?
I have a column with submittal date and this information will be reviewed the following Monday, then will be up for approval the Wednesday after that. Is there a way to create a review date and approval date? I submit date on 5/17/22, I want a calculated date for the following Monday 5/23/22 then another for Wednesday…
