-
Calendar app not showing line items when more than one value chosen in a multi-select filter
I can see line items properly in regular SS calendar view but in the calendar app it is not displaying items it should when I filter for line items that have more than one value selected in a multi-select column. When no filter is selected, the line items appear. The filter works when i chose ONE value but not when i chose…
-
Trigger Outlook Calendar Event from Form Submission
I've created a form for my team to use to submit vacation requests with a manager approval and user alert workflow. I want to be able to have an Outlook calendar event added once the vacation request is approved by a manager. Any thoughts on how to achieve this?
-
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…
-
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…
