-
Formula Help - Predecessors disabled/Duration calculated formula to exclude holidays
Hello Smartsheet Community I had to disable predecessors in this project plan. I worked with the ProDesk to come up with a way to have a calculated weighted formula. There is also a formula that calculate the # of days between start date and end date. However, I just realized that this formula does not excludes holidays.…
-
Parent Row Status Formula
Hi all, There are tons of parent status row formulas on this site and I have to first say a huge thank you to the contributors because you've helped me resolve my own problems without opening a new question. Here is my current formula based on the great input I've read from the community: =IF(COUNT(CHILDREN()) =…
-
How can "successors()" just show direct successors?
Hi - I find a "successors" column useful. I can easily make a column with a column-formula of JOIN(SUCCESSORS(X@row),", ") - great. But if the successor is a parent row, I get not only the successor row shown but also all of the children of that row. Like this: I don't want to know that the tasks on lines 3 and 4 are…
-
Hi, I'm trying to reference a cell that contains a dollar amount based on a date range.
This is what I'm trying (unsuccessfully to accomplish) =IF([DATE SUBMITTED]@row >= DATE(2022, 12, 1), [DATE SUBMITTED]@row <= DATE(2022, 12, 28), "PO Amount Including Change Orders" Looking for the amount in "PO Amount Including Change Orders" to show up if the cell "Date Submitted" falls within the date span. Any ideas?…
-
Remove partial text at beginning of cell
Hello! I'm trying to use a formula to eliminate the first 4 characters at the beginning of a cell. Help would be greatly appreciated!
-
Formulas to Indicate Date and Time Already Scheduled to Trigger Alert
I am trying to create a form for people to use to sign up for a specific date and time (e.g., 12/12/22 @ 11:30 a.m.) to pick up some work equipment. I created a (1) sign up sheet to capture the form data and (2) a separate sheet containing all dates and times to be scheduled. In the dates and times sheet, I have a column…
-
Formula for calculating today minus the case created date
Hi, I'm a new user here. What is the equivalent formula from google spreadsheet to smart sheet if for example, C2 is the cell with Case Created Date? =TODAY()-C2 I'm trying to show the actual case age without including the weekends and holidays. Thank you in advance for the one who will answer.
-
How do you make a name input on a form become a contact that is already a contact in Smartsheet?
I posted this on an old thread, but thought it might be easier to find as a new entry. I am trying to have a contact show up in cells based on input on a form. User fills out form with account manager name. For example, Rachel Alexander. Rachel is in my contacts. However, when the data from the form populates the sheet it…
-
RAG Automation: Difference Between 2 Dates
Good Day Smartsheet Community: I am Trying to Modify the Formula Below to Add Yellow if The Difference Between Plan Vs Actual is 4 Days Behind Plan, otherwise greater than 4 Days Behind Plan is Red =IF([Milestone Date (Plan)]@row = [Milestone Date (Actual)]@row, "Green", IF([Milestone Date (Plan)]@row > [Milestone Date…
-
How do I remove the leading "$" of a Price column so I can then use SUM
Hi all, I am a complete novice here. I have imported an XLS spreadsheet and one of the columns has "Sales Price (Converted)" It has a leading "$" that I am trying to remove to sum the prices. Can anyone help me with a formula to remove that leading "$" please?
