-
If the value is negative, make it 0
My problem is that I have a formula that takes into consideration the Start Date and End Date of a task, then divides its by duration as you can see in the attachment to give me a expected progress percentage of what I should have accomplished for that task by the current day. When I have a future start and end date I get…
-
Set up conditional formatting in dates, with additional variants
I know how to set the conditional formatting to have a date cell turn red when the task is due in the next X days (for example). But is there a way to do it only if the Status (another column) is not in "Complete"? So something like: If Status is "In progress", "In review", or "Not Started", AND Due Date is in the next 2…
-
Formula Help - IRAAD Profile Data + IRAAD ID
Hello Smartsheet Community Just needing a little more formula help. I have an IRAAD that is being provisioned through a control center blueprint. In this IRAAD I need to add a column formula under the IRAAD Identifier Column. I need to create a unique identifier that takes the Business Partner Alias Profile Data under the…
-
Intake Form Question
I would like to know if this is possible. I have an intake form with a dropdown that has different portfolios to choose from. Let's say they are called Portfolio 1, Portfolio 2, and Portfolio 3. If someone selects Portfolio one, I would like for the intake sheet to automatically assign the project to Assignee 1 on the…
-
NEED HELP WITH FORMULA: Status Based on Target End Date, Actual End Date and "At Risk" flag
So this is my current formula: =IF(OR([Task Name]@row = "Initiative/Program Overview", Program@row = "Initiative/Program Overview"), "", IF(AND(ISDATE([Actual End Date]@row), [Actual End Date]@row <= [Target End Date]@row), "Completed On Time", IF([Actual End Date]@row > [Target End Date]@row, "Completed Late",…
-
Hiding Personal User Data
Hello All I have a process I am trying to build for my HR department to automate communication and requests. The process I have in my BETA environment: One dashboard with a form and a report widget, all user connect to the same dashboard. The form allows users to enter a request to the HR department, the request will…
-
SUMIFS OR question
I have this formula that works with the "CONTAINS" function, but I now want it to equal that number instead of contains (as the contains doesn't work if it equals oddly enough). =SUMIFS({TOTAL COST - Costing Sheet}, {CODE - Costing Sheet}, OR(CONTAINS("300", @cell), CONTAINS("301", @cell), CONTAINS("302", @cell),…
-
auto populate a column with NO formula
Is it possible? Can you write a formula in column 5 to populate column 4? I need Column 4 to just rewrite what is in Column 3, BUT the formula will need to be in column 5. And it only needs to it to be written if column 6 has text. We testing and hoping for a new way to populate a sheets column. Essentially, column 3 and 4…
-
Insert the month based on date
I'm trying to insert a formula to return the month i.e. January depending on a date. The formula I have inserted is =IF(MONTH([Start Date]@row) = 1, "January, IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 3, "March", IF(MONTH([Start Date]@row) = 4, "April", IF(MONTH([Start Date]@row) = 5, "May",…
-
Solution for Table Join-Like Behavior
I'm looking for some ideas... Being that Smartsheet is a project management software, I imagine there is at least one person doing something like this! Some Background For apartment complex renovation projects, we have a list of tasks that are repeated across many apartment units. Inside of that task list, there are also…
