-
Back up not complete
I requested a back up of my smart sheet on the 24th. It is still pending. Who do I contact to get that back up. Smart sheets won't let me attempt another back up with that one still pending.
-
Checking for conflicting assignment dates across two columns
Long time reader, first time poster--this one has a few people stumped. I have a variety of events with Start Dates & End Dates. Staff members are assigned as a 1st Guide or 2nd Guide (its critical we differentiate which role they have been assigned). I am looking for a way to pop a warning symbol when one of the names is…
-
Auto Reply to Form Submissions
Hello Team, I was trying to setup automatic replies to people who enter their email and select a certain timeframe. I would then like to send an automatic reply with information regarding the session that they signed up for. Is this possible using workflows? I can't seem to select a contact in the "Send to contacts in a…
-
Formula to calculate difference between projected and actual dates
I have a project schedule where I have projected and actual dates for most of the deliverables, and I need to track the faster project path. Is there a formula that can automatically select the earlier date between the projected submit date and actual submit date? Is there a formula that will automatically select the…
-
COUNTIFS on specific days and net change over time from report
Hello all, I am struggling on finding a solution for this. From our calendar, when we have issues, we log the issue in the notes section, categorize the main issue, and change the "Incomplete Job" column to Job down or go back. When the "Incomplete Job" changes, I have an automation to record the date in the column, "Date…
-
Vacation & Time-Off Management
Has anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
-
Calendar View from Grid with Linked Cell (as Dates) not Populating Calendar
I have a calculations grid that summarizes a large data set (populated by formulas against a main grid). To do this, I had to create helper cells that are rather ugly and should not be seen by my audience. As a result, I created a new Grid (Reporting Grid) that is linked to the calculations grid. It's a grid made up of…
-
Calendar View
Is there any way to display 2 columns in calendar view. We are a construction company, who is now using smartsheet for all our scheduling of sub contractors. I would luv the calendar to show the task Steel Delivery and the vendor/sub we use on the dates. Now we have looked at the calendar app and it is way to clunky for us…
-
Automatically creating event recurrences
Hi All - I am creating an event calendar (to be coupled with the Calendar App) and I would like to enable folks to submit a recurring event, noting the frequency as once a week, every 3rd Thursday, etc. I capture the initial start date, but cannot figure out how to automatically generate the additional rows with…
-
How to Multi-select column show on Calendar
i have a multi-select column on the sheet summary report. like to show the selection selected from the multi-select column to show on the Calendar app and add filters from the multi-select column. any suggestion?