-
Changes since last week
Hello, Is there a way to show changes since last week to a 'date' column? I don't want to highlight the change, I want to be able to see if the date moved since last week and then calculate the number of days it moved (eg: +10) I don't want to right click and view cell history either. I want to show a simple report/project…
-
How to make the cell blank if the other cells used in my formula are blank?
Hi everyone, I'm new to using formulas in SmartSheet. I currently have a formula for one of my rows which works properly (thanks to the help of a member here!): "=IF(GLP@row <> "YES", IF([Expiration Date]@row < TODAY(), "YES", "NO"), IF([Expiration Date]@row < TODAY(-365), "YES", "NO"))" (Basically, the cell marks "YES" if…
-
Changing hyperlink to Text in an alert
Hi, I am setting up an alert on my smartsheet. I am able to get the message to include the hyperlink to the form i want filled out. However is there any way to change the long hyperlink to text in the alert? IE https://app.smartsheet.com/b/form/64b6174ede52498c8d8c4e30075b9535 would show as, Let us know what you think…
-
Automation of renewal date update, based on the renewal date being reached.
I am looking for a formula in which can be used to update a date in a cell and is triggered when the date is reached. For example- If the renewal date is 10/02/20 and the next renewal is 1 year from this date, I would like it to add 365 days to the renewal date when the date is reached. I have found IF statements, but they…
-
Is it possible to automatically update the sheet summary when a new row is added?
I have a sheet with an associated web form where users request a shirt size. At the top of my sheet, I have the number of shirts in each size that I have ordered. In the sheet summary, I have the formula: =[Youth Large]1 - SUM([Youth Large]2:[Youth Large]107) This calculates the number of YL shirts I ordered - the total…
-
Automate RYG For Project Tasks
Hi All i am very new to SmartSheet. I am working on the project template which can help to highlight some tasks that have been overdue with RYG. Need your kindly help on the formula... 1. If task status is complete: Green 2. If the task status is Not Started: 1. Scheduled End Date is behind today: Grey. 2. Scheduled End…
-
Counting Checkboxes NOT Checked within a Specific Range for Sheet Summary
Hello all and Happy Friday! I need to count the number of checkboxes that are NOT checked within a given range in a column. I have found formulas to count checkboxes NOT checked for an entire column, that seems to also count all "blank" cells below my data range, so its providing incorrect counts. Example sheet is linked…
-
Regarding Column Properties
I added a column for Status. The column property is "checkbox". On other sheets I have worked in, when you check an item as "done" or "complete" it crossed off the row. It is still visible but the text is light and there is an actual line through the row. I can't seem to duplicate this on my sheets.
-
Use a multi select drop down option to check a box
I have a drop down where you can select more than one option from the list as a status. I would like if Option "Canceled" is selected for a check box to be checked in column Canceled. Here is my if statement =IF([Info Center]1, "Canceled", 1) If Info Center shows Cancelled the check box says #Invalid if Info Center is…
-
How to keep a function in a cell after selecting a value from a drop-down
Hi Everyone, I'm starting on Workflows now and I have a column called STATUS with drop-down values of Open, Sent for Approval and Closed. Additionally I want this formula on the STATUS column - If the Review Step Approval, set to Approved otherwise Closed. So I when the Approver, approves the work (The workflow logic sets…
