Hello All, I am trying to create a smartsheet to optimize a process. Basically what I need is a statement to recognize if a cell has a specific text value (for example CUP). If the cell contains the v…
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying…
I am looking to compare Year to Date numbers, and I'm having a hard time figuring out a formula to do so. I've attached a sample screen shot. At the end of the day, I'm trying to add a metric into a d…
Forum Id like to create a formula that mirrors 'Concatenate' from Excel, so Id like 3 items concatenated; 2 sources from 2 columns on my sheet and the third is a manually written in text string with t…
Boy have I gone round and round with this! This formula is meant to bring back the data from another sheet based on the code entered (ie: code - CALVE and it should return the full name, email of that…
Hello, I'm looking for support on what formula to include in the Flag symbol column that would act against the following: If Due Date is in the past and Complete = X (Visual Symbol), then flag At Risk…
I have a running list of estimates we submit. when we are awarded the project that column gets checked. im looking for a way to scan the entire column and report back the percentage of estimates we ha…
Spent a lot of time on this and I'm sure I'm just missing it so if anyone could help, I'd appreciate it. I'm trying to create a formula where it will check a box if either one of these 2 scenarios hap…
Hi, What is the way to make date change every day automatically and also I do not want the dates of previous operations to change, I just want to change dates for new processes, is there a formula for…
Hello Community, I'm trying to establish an RYG Status column formula in my sheet based on values in three other columns. One is a STATUS column with drop-down selections of Completed, Not Started, In…
