-
Linking
I was wondering if smartsheet linking has the capability to perform this following type of function: If I create a Request Log spreadsheet, and one of those columns has a drop down with options, approved, hold, pending, is it possible to create a function wherein once that approved selections has been made then that row of…
-
Conditional Formatting
I want cells that need to be filled in with values to be highlighted. Like, if A2 and B2 contain a value, highlight C2. Only problem is that C2 has a formula so it's not technically "blank". And I want the formatting to go away once the formula has been overwritten. The formula is there because if someone indicates "Y" in…
-
Another parent-child condition format scenario
I've search Community and found several very excellent formulas that fall into the parent-child conditional format category; however, they rely on a checkbox type to function. In my scenario, the child row has a conditional format that when a date is within 15 days of target date, the row is highlighted. I'd like the…
-
Conditional Formatting or Formula
Good Day All: I am trying to use Greater Than Conditional Formatting for two columns. However, Conditional Formatting does not allow you to select 2 columns. Perhaps, I have to use a formula? Here is what I would like to do: If % Complete (Planned) is Greater than % Complete (Actual), then Red If % Complete (Planned) is…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
-
Sort columns by color
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
-
Keep users from back-filling completed dates
is there a way to set a date column so that only the current date can be entered? Right now we have START, DUE AND COMPLETED DATE columns. The problem is that people are back-filling the completed date, for example putting in a 3/1 completed date on 4/1. We would like to get people to fill in the completed date on the…
-
conditional formatting between 2 columns, same row
is there an ability to set a conditional format based on two columns in the same row: completed (column) date is later than the due (column) date – the cell turns red completed date entered is before (or after) today's date
-
copying rows to another sheet
Is it possible to set up automate action to copy certain rows when check box is checked ?
-
Risk Status on my Smartsheet using formulas
I am using Blue, Green, Yellow and Red for my project status - I have a formula around it that will change the color accordingly. What I want to do is if the color ever turns Yellow or Red log it as a risk in another column. I can get it to work but if it is ever a risk I want it to remain a risk even if the task turns…