-
Reference Criteria-Result For Today Or 1 Day Ago
Smartsheet Community: Can Someone Help Me Modify My Existing Formula? I am Trying To Add to My Formula to Look For Anything Done or in UAT Today Or The Previous Day, excluding Weekends. Here is My Current Formula: =COUNTIFS({Jira Status}, OR(@cell = "Done", @cell = "UAT"), {Assignee}, "Isha", {Resolve Date}, TODAY()) Thanks
-
Formula for Find
Hello- Is there a formula I can add on this below. I need to get the Customer's name, like the one on the 5th row. I'm getting Invalid value. Thanks. =MID([Opportunity Name]@row, FIND("~", SUBSTITUTE([Opportunity Name]@row, "-", "~", 5)) + 1, FIND("~", SUBSTITUTE([Opportunity Name]@row, "-", "~", 6)) - 1 - FIND("~",…
-
Join two columns
I have a column for first name and one for last name that I would like to join together in a column called combined name. This is what I tried and it doesn't work: =JOIN([First Name]@row, [Last Name]@row])
-
Formula Check Box
Hi There, I need help with implementing "Checked" vs "unchecked" symbol into my formula. Online I saw " Checked" and "Unchecked" and that didn't work for me. My formula : =IF([Founder?]@row = "", [First Name]@row + " " + [Last Name]@row + " is a founder of " + [Name of Company]@row + ".", IF([Founder?]@row = "", [First…
-
Automations working/not working/working
Has anyone experienced Automations sometimes not working, then the next day they work fine? I have had this happen a few times. On occasion I have to Save as New to regenerate the sheet (per Smartsheet support) to get the Automations to work. Sometimes I don't do anything. Sometimes I remove the trigger, save and add the…
-
Formula for calculating escalating values
I am completely stumped with how to start this formula. It is in reference to billing false alarms occurring in a month. The first 1 is $50, a 2nd is $100, after 3, it jumps to $200 each. If there were 5 false alarms in the month, the total would be $750 (1@$50, 1@$100, 3@$200). Any help would be appreciated.
-
Accumulated Value Column
Hi, Has anyone faced the need to use an accumulated value column? This has been around for years for those who need to programm an accumulation of historical values in other apps and I have done it using multiple rows to record individual changes then another column to record the accumulation. Nothing super fancy really…
-
Get the Percentage Compared to a Total
I know I'm overthinking this but I haven't worked much with %'s quite yet in SmartSheet. I'm basically just needed to get a percentage of how much Soft Costs and Hard Costs take from the total budget So I have the [Construction Loan Amount] column which is my total overall. I need to take the [Soft Cost $$] and [Hard Cost…
-
Health Status
Hi! The sheet that I am developing has items with a due date far in advance. I would like to have my "Health" column show a Grey symbol for items that have not yet started that are more than 60 days out. =IF(AND([% Complete]@row < 0.25, [End Date]@row < TODAY(15)), "Red", IF(AND([% Complete]@row < 0.75, [End Date]@row <…
-
IF AND OR Formula
What is the easiest way to set up a formula using the IF AND OR functions? I want my flags to turn red IF a Status is not marked Complete OR In Progress AND the Due Date is TODAY or later. This is what I currently have (it's incorrect): =IF(AND(Status@row <> "Complete", OR(Status@row <> "In Progress", [End Date]@row <=…