-
Background auto-refresh a sheet as frequently as every minute.
This might be my first real contribution to this community, but I think I have had a breakthrough with respect to background auto refreshing a sheet. I've seen the common solution of utilizing a workflow to trigger a daily update of a date column, but the challenge has always been that you are obviously limited in how…
-
CHECK BOX IF TWO CELLS MET THE CRITERIA
Hello, as you can see, I have a form and if a employee selected a certain date and certain time, what is the formula to tick or check the box on the circled part of the picture. Please share with me the formula. Thank you
-
REMOVE IF SLOT IS TAKE
Hello! Can we remove a time slot in the drop down on a specific date if it is taken. Below is an example. For example if someone Booked - Dec. 31, 2023 - 9:00AM - 9:20AM, can we automatically remove that from the drop down list since someone booked it? What are the ways?
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
Can I trigger an update request once the date is 'today's' date
I want to send an update request once the date in a cell is reached. I have set the trigger to be when the cell value is "=[TODAY]" but that doesn't seem to be working.. Can someone help with either my cell settings or the workflow automation settings?
-
Can I set Series of SMS (Drip SMS) for Smartsheet reminders?
I'm curious about using a series of text messages (Drip SMS) for reminders in Smartsheet. Has anyone successfully implemented this feature?
-
Add 'Refresh Sheet' to work flow
I have a sheet which is full of formulas pulling data from a number of different sheets in order to graph the data onto a dashboard. I have noticed some issues when looking at the graph on the dashboard recently and have just figured out it is because the sheet requires updating. A few of my formulae reference TODAY(), to…
-
What is the simplest way to have data from a form be pulled monthly into reports/dashboard
I have created a smartsheet form to log information on service intakes. I have then created sheet summaries and reports with a bunch of information (age, demographic, reason for call, type of service requested etc.). From this I created a dashboard showing key metrics and graphs of my data. My challenge is now I would like…
-
Is there a way to turn off email confirmations/receipts after the approval?
Hi- While using the automated approval process, users are getting additional e-mail after they approve the request. Is there a way to disable that? It just creates unnecessary e-mails and notifications serves to very little to no purpose. Which sort of contradicts with the purpose of the Smartsheet. Regards, Enes Z
-
Can I reply from my outlook with an attachment, and it gets added to a row?
Lets say I have and email auto response to someone. saying please add a pdf Can they respond to the automation from their email with an attachment and it gets added to the row? I know the smartsheet outlook app could do it but can I make it automatic? Or is there anyway to auto add attachments to rows? Does an API have to…