-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
Parse Out Number Values in Successor Column
I have found multiple threads on this but I can't seem to get any specific formula to work for me. I have a column to Join Successors =JOIN(SUCCESSORS(Name@row), ",") The highest number of Successors I have is 4 and I'm trying to parse them out into separate columns. I have formulas that work for three but can't figure one…
-
Formula that calculates the multiple choices chosen from a drop-down list
I need a formula that calculates the choices from a multiple selections row. I am currently using the formula =COUNTIF({Link Access}, "Overdue Report")
-
Budget Tracking
Hi, I'm trying to put together a budget for change orders and I want to have the value of the "total" cell of the change order show in a "remaining" cell if "NO" is selected from a drop down. I have been messing with the automation for an hour and I just can't figure out what the formula needs to say to show the value.…
-
Workflow failed due to linked cells. Need help writing formula for Status changes.
I have the following Smartsheet and am trying to automate Status changes based on start and end dates, but from what I've read, I can't do that since my Start Date values are linked cells. Can someone help me write a formula for the Status column to populate either: Not Started, In Progress, Complete, Overdue based on the…
-
Please fix my syntax
Ok, I know it's something small but I can't see it. Can someone please tell me what is wrong with my formula? I'm getting an Incorrect Argument Set =COUNTIFS(Urgency:Urgency, "1 - URGENT Need attention today", Status:Status, "Pending (awaiting response)", "Working on it") tagging my formula guru @Paul Newcome
-
How to Add period only if there isn't one already?
Hello i am currently trying to use a formula that will take a name from a cell and add a period to it since it it the end of the sentence. This is the formula i use. =[Name]@row + "." The problem is, is that some of the names have periods already at the end because its words like Inc. or LLC. so how would I make it add a…
-
Forumla to add a date
Hello - I'm trying to write a formula to add a date in a cell if a checkbox in another cell is not checked, like the image below. If there is a check in "transfer to tier 2" I want closed to be blank, if there is not a check, I want it to have the date the row was entered. Can anyone assist? I've looked at automations to…
-
Counting Dates less than 90 days from today
Hi there. I'm trying to write a formula that will tell me how may dates are less than 90 days from today. Here is what I thought should work, but it doesn't. I feel like I'm close. What am I missing? Here is the formula I have. =COUNTIF([Start Date]:[Start Date])@row, TODAY-90) Thank, Tony Cooper
