-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
-
Timestamp for changes in each row
Hello, I created a "Modified" column in smartsheet to track changes for each change within that row. It appears to be constantly changing in the entire COLUMN whenever any thing is changed in the sheet. This is a major problem since my formulas are referring to the cell that has the last change mod done to it. Is there a…
-
how open a link from a Hyperlink cell
Dear all I've crated some hyperlink to local directories, I'd like to be able to open link when I clic on them (Only cell edition is available, to change the value) Thx
-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,…
-
Labels for RYG Balls
Hello I am sure it is an easy answer, but, I cant seem to find information. Is there a way of having a label associated with one of the RYG balls, ie when the green ball is selected, the next column says 'Active', The red ball would be 'On Hold' etc.
-
Symbols and Dropdown list
Is there anyway to associate dropdown list with symbols for display in card view?
-
How to Trigger Formatting from Comparison / Nested IF?
Hello! I have project sheet, with dependencies enabled. This requires manually updating the % Complete value. I would like to add conditional formatting to remind myself to update the % Complete. IF [Completed]1 is not blank and IF [% Complete]1 does not equal 100% Then Format [% Complete]1 Cell Fill Yellow (screenshot…
-
Running formulas
It appears as though you have to open a sheet for a formula to run. Is this correct? I have reports that show out of date data due to the sheet not being opened therefore causing the formula to activate. Any suggestions? Thanks in advance. Richard
-
Automate RYGB based on Follow-up Date by Week
Community: I have tried but cannot figure out how to make this formula work. Probably something very simple, and I am overthinking. Any guidance would be much appreciated. Thank you, Sandy Scenario: Regardless of the day of the week I open my sheet: If [Follow-up date]1 is between M - F of the current week, RYGB symbol =…
-
Sumif /Sumifs
Having trouble getting the sumif function to work. I have tried 2 versions, below =SUMIFS([Days Open]:[Days Open], Location:Location, [Repair Description]17) =SUMIF(Location:Location, [Repair Description]15, [Days Open]:[Days Open]) The [Days Open] is a number calculated by subtracting 2 dates (the cells with functions)…