-
Hyperlink in Alert/ Automation
Hi, I would like to add a hyperlink to a Smartsheet report in an alert. The idea is that I want to direct the alert recipients to go to this report to complete a task. Is there anyway to get a hyperlink into the body text of the email alert? Otherwise I need to put the entire url into the body of the alert, and the…
-
How to set recurring reminders
I have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula (my Excel is rusty)? I want to have an email reminder sent daily until the task has…
-
Times in Outlook Calendar Syncing
I haven't been able to find a way include times with Outlook Calendar sharing after the last Outlook update. Any help on how I cna do this so that each event isn't listed as an "All Day" item would be great. Thanks
-
Smartsheet at- risk formula
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column. I only want the column to flag is the status is not complete and the target end date is past due. My current formula is =IF(AND(Status301 <> "Complete", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…
-
How to pull rows from a different sheet only if they're marked as "in progress" ?
Hi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single cell. Is there a way to do this? Thanks in advance!
-
Drop Downs
I'm using multiple dropdown columns on my smartsheet, most work, but a couple don't. When I try to click on the dropdown, nothing happens. Not sure why?
-
Help on IF Formula - Multiple Statements
Hi! I need some help on a IF Formula statement. On my sheet, I have a column that is using this equation - =IF([Total ALL Athletes and Unified Partners]@row = 0, "0", IF([Total ALL Athletes and Unified Partners]@row <= 5, "1", IF([Total ALL Athletes and Unified Partners]@row <= 74, "2", IF([Total ALL Athletes and Unified…
-
Is there a way to have a flag automatically turn red if a Priority column is "A"?
-
Customized Deactivated Web Form Message
Hello, I was wondering if it is possible to customize message for deactivated form? When we deactivate it shows error message "The form you are attempting to access is no longer active" which sometimes is confusing for people who are trying to register. Many thanks in advance!
-
Automation 'Copy to another sheet' doesn't work
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automation rule to not only copy my rows, but also send me a notification when this field…