-
Updating/Refreshing my file from a different website?
I have a file that I need to use updated fuel pricing at all times. The website my excel file is linked to updates once a week, usually on Tuesday. Need: How can I have this sheet refreshed from the website (EIA.gov) onto my Smartsheet file? Nice to have: I would like the data point I use on the sheet to be rounded to 2…
-
Expand (wrap text) and Color Code in Card View
You can see below by the +2 and +1 that more information exists. I know you can float over it to see what is there, but I would prefer to have the card expand to show them all. Is that possible? Also, I'd like different options to display in different colors - how might I do that?
-
Conditional Formatting Not Transferring to Card View
I set up conditional formatting which works in my grid view, but when I switch to card view, it is not showing the correct formatting. Here are some screen shots. Thoughts/Suggestions?
-
alert with specific row
How can I set up to send an alert for specific row when it matched a condition . I tested it and it triggers correctly but always send the first row. for example, it should send out the 10/10/2022 row only, but it sends out 10/2/2022 row any idea? Thank you
-
Highlight a specific cell not the entire column/row
I'm looking to only have child rows highlighted when the value is greater than one. Currently conditional formatting only allows for applying a format to an entire row, or to all the cells within a column (Parent + Child) are there any formulas I can embed in a child row cell that will only highlight for that specific cell?
-
Remove conditional formatting
Can I remove conditional formatting from a cell? I've built a plan with multiple dates for action steps in columns for each row and need to lean on CF to highlight late and upcoming activities. Once the activity is completed, removing the cell color (or remove CP) would help indicate that its "completed". Thank you
-
Is there a conditional formatting rule that shows if a date is more than X years in the past?
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. I can only find the function for "in the past" without any way to add to the formula how far in the past. Is it possible to set parameters on past dates? It seems like this should be…
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
Conditioning logic to be AND not OR in form
Hi there, I am needing to build in logic to a form whereby a question shows if a specific answer to 1 AND 2 is selected and not OR. Question 1 : A, B or C Question 2: X, Y or Z Question 3: Appears if answer to Q1 is C and answer to Q2 is Y. Currently this is showing if answer to Q1 is C or if answer to Q2 is Y. I need it…
-
Conditional Formatting Referencing Other Sheets
Hello, I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names…