-
Every 2 Weeks Alert Not Working
I set up an alert that says send an alert every 2 weeks starting on Monday, Nov 4 @ 9 a.m., the condition is the status must be 'Open." However, it doesn't send. If I sent it to weekly, hourly, daily, it works but the every 2 weeks won't send. What am I doing wrong?
-
Flag By Issue Status Formlua
This seems so basic, but I cant get this formula to work. I have a flag colum that I want the flag to be 'flagged' if the Issue status column has an issue listed as "Open" This is what I'm using and getting an unparseable =IF(Issue@row = Open, 1,0) Thanks in advance!
-
Auto-Notifcations not working?
It appears since 10/25 auto-notifications for a built workflow are not working (at least nothing was triggered for any submission on 10/29)...is anyone else having this issue?
-
extracting the email adress of a contact
Hi, I'm not able to use the email adress of a contact in another cell. I need this for building a specific link in another cell. e.g. https://blabla.com/#browse/profile/john.doe@gmail.com ="https://blabla.com/#browse/profile/" + contact2 will not work :-(, it returns the name of the contact. Any idea how to get this…
-
Watchlist Alert
Hi there, So I am trying to the set up an Automation workflow for the following scenario: If the task status is still in progress or not started, then the system will send a select user a notification 30 days after the set END DATE. This is what I set up in the workflow, but I don't believe this is correct.
-
Alert notification are not sent anymore
From beginning of the week all alerts form my smart sheet are not sent anymore. I have not change any workflow settings. last week everything was ok. I have the same problem on my all smart sheets. Please help. Attached workflow
-
Automation from a form submission
Hi I have created a form that is working perfectly in that once completed it is populating the sheet data. I have also created a number of automation work flows that work if you directly input into the sheet but do not appear to work if the data is entered via the form - please can anyone advise if I have missed a step or…
-
Can information be pushed into a SmartSheet from an email message
Hi there, I am curious to find out if I can embed a button (or link) into an email that would make an entry into a SmartSheet. Let's say I want to send an email which asks the recipient to choose one of two options. I could send them to a SmartSheet form and have them fill it out, but what I would rather do is have them…
-
Countif lookup by email/contact
Hello - I have a sheet ("Sheet 1") where users enter various entries/plans, etc. via a form and to associate it with themselves, I have them use their email address which logs into a contact column. In another sheet ("Sheet 2")- I have a list of everyone who is expected to put in information. I have a contact column with…
-
Teams Integration
Hi All, I have been tasked by my manager to incorporate SmartSheet into Teams. We have completed the integration and I can now see the shared sheets in Teams without issue. We would like to go a step further and be able to receive notifications in Teams when certain fields are completed on the Sheet. Is this possible?…
