-
Created Date, error when referenced in formula
{Date Submitted} is a cross-sheet reference to a column of Created (Date). {Total Findings} is a cross-sheet reference to a column of numbers generated via a formula. [Week Number]@row is a primary column with numbers in it. Formula 1 below works fine. However, formula 2 returns a #INVALID DATA TYPE. How is this possible?…
-
Flag or Conditional Formatting?
I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that? I thought I had…
-
Creating a Formula for Dates and Traffic Lights
Hi, all! Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - formatted as a green traffic light * "60 Days Since Contact" - formatted as a yellow traffic light * "90 Days…
-
Formula to change line item to 'at risk' when due date is passed
Goal: When a finish date is passed on a line item, I want the status column to change to 'at risk'.
-
Archiving Design Pattern in Smartsheet
Hello, We currently have a very large Smartsheet we use to collaborate with external business partners. I have created workflows to add rows each week, and our cross-functional teams complete tasks related to each of these rows over a period of weeks. We are struggling to find the best way to declutter this sheet once all…
-
Formula to show text next to sum amount
Good day, Our Currency ( BHD for Bahrain Kingdom ) is not one of listed currencies and I wish to show it to amount numbers , how to have Currency BHD seen next tp total sum in below formula ? =SUM([Service Charge]4:[Service Charge]13) Also , is there a way or formula to show text ( BHD ) or any other text next to number…
-
IF/AND, OR
Hi All, Smartsheet newbie here 👋 trying to figure out what seems to be a basic formula with no luck... I would like my "At Risk" column flag to get checked if the "Due" column date is past today OR if the "At Risk" dropdown is selected on the "Status" column. Here's my started formula that doesn't include the OR:…
-
Project Health formula Help needed
=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", IF(TODAY(10) >= [End Date]@row, IF([% Complete]@row < 0.75, "Yellow", "Green")))) These is what I want the rules around the health to be but when i enter the above formula the cell is blank some of the time. If scheduled end date is…
-
Formula - Completed projects in a given year
Hello, The formula pasted below works great if I want to count the number of projects completed in a year. How can I revise the formula so that I can count the number of projects completed in 2020? Thanks!
-
Automating Status of "Completed"
I want to be able to have all tasks with a status of "completed" moved to the bottom of my parent section. I don't want to move to another sheet, but instead to the bottom of the parent. Is there a way to do this? Formula / Automation? Thanks in advance! -mc