-
How to connect symbols with text
Hi, I'm trying to connect the symbols to a column for "not started", "In progress", "Complete". Is there any way I can do it? I'm trying to change the text automatically when an assigned person change the status of the project. Please see the attached screenshot.
-
Replicating Formula
I am having an issue where I have a formula working on one sheet but when I copy the formula to perform the exact same function on a different sheet, it does not work. I'm hoping someone could look at both sheets and let me know what I'm doing wrong.
-
Getting top-level heading's rank
I'm trying to write a formula that extracts the position of the current hierarchy's top-level heading within the set of all top-level headings. The purpose is to drive some conditional formatting. i.e. If the current row is under the first top-level heading, make it green. If it's under the second top-level heading, make…
-
Adding in multiple durations to Start Time formula
Hello! I originally created my plan using to have start date then to add in the start and end times. I was using this formula: =StartDate@row + duration@row + "". However, I just realized that my project will be operating under two sets of working times: 8 hours to start then pivoting to 24 hour days. Since smartsheet only…
-
Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally). But with cell linking…
-
If this, then that formula question
Hello! this may be so simple, but I'm having a hard time with it. I want a few things to happen - if the Approx trips per year is blank: provide the sum of just the Registration price field & the Approximate travel field If the Approv trips per year is NOT blank: multiply the approx trips per year by the apprx travel cost,…
-
Formula Help
Hi, I have a due date column and a status column. The different options for status's in the status column are - In Progress At-Risk Completed Postponed What I would like is a formula that can do the following - IF due date is empty or prior to date listed - mark status column to In Progress IF due date is within 2 days -…
-
Changing a cell's values from code in a different cell
Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF(column@row=X, different_cell=XX, different_cell=XXX)
-
Formula for non-duplicate values
Hi, Is there any formula to populate only 1 value of each value listed [Column1]? I.e., column 1 has something like the below, 45 56 45 55 55 56 46 56 Is there any formula to only show the below? 45 46 55 56 Thank you!
-
Can't add days to a Date
Hi, It seems like I cannot add days to a date by a formula. Formula is below: =[CX Finish Date (F)]@row + 2 And see the Screen shot below, above formula adds the number "2" to the end of the date as a text. However, it is expected to have 2 days added up to the date that was selected. Thank you in advance.