-
Item Request
Hello, I am creating an item request/reservation form for check out/in of a limited number of headsets, 6 items. I am trying to determine a way for the sheet automation to look at the date a headset is requested and send a confirmation if that date is available for one or a denial if all six are already reserved for that…
-
Dynamic View Automation or anything that could help me in Smartsheet?
Hello, I’ve been using Smartsheet for 5 months and have a question about creating personalized views (Dynamic View) for each of our 300+ customers. Each view will have identical columns but different rows of data. We plan to have each customer create a Smartsheet account for individual tracking. Is there a way to automate…
-
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…