-
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…
-
Duration and finish dates
Hello Is it possible to create a Formula or another way to do the following example: Industry Injection mold making I have allotted 5 days for a task. ie starting on Monday- finish Friday once finished they move to the next operation. start on the following Monday I have a check box to machine the parts. in progress…
-
SUMIFS 3 criterias
Hi, I'm trying to create a formula with 3 criteria but it doesn't work. Here it is: =SUMIFS({Hours (1)}, {Période de paie ING}, [Période de paie]@row, {Centre de coûts Projets 1}, [Numéro de projet]@row, {Colonne Employee name}, {Alberto}) When I remove one of the criteria (no matter which one), the formula works well! I…
