-
Combining IF(AND and IF(OR statements
Hi all, I am trying to build a combined IF statement for a date validation field. Both of these statements work on their own. The first statement returns "University Holiday" if the "Preferred Date" is a holiday... =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19",…
-
percent column - are we all just guessing?
We're implementing a new template set for projects after some great sessions at ENGAGE. I'm writing some automations and getting things ready for end users to test but I keep coming back to the percent column. I'm stumped - how are others selecting or defining their percentages as a project progresses? How do we…
-
How are institutions using Smartsheet to manage incident reporting workflows?
Hello, How are institutions using Smartsheet to manage incident reporting workflows that involve notifying multiple departments, each responsible for investigating and reporting back? I'm interested in examples or ideas on how to set up the sheets and workflow to streamline this process.
-
Submitting Multiple Rows using one Smartsheet Form
We are creating a new Smartsheet to track deliverables. We have asked competing vendors to add delivery details within a ‘Smartsheet Form’ to auto-populate the sheet. Orders contain 1 to 100 shipments. Our Order Number is the same for all shipments. Ideally the vendor would like to enter the Order Number and the Order…
-
Is there a way to utilize one sheet for multiple projects, but still roll up into a dashboard?
I work in an IT department as part of a fairly large school district. We typically don't super fancy PM tools other than a project name, all the tasks associated with that project, who is doing those tasks, and when they need to be completed. So each division in our department has setup their own sheet which as multiple…
-
Discount codes for core self paced class
As a relatively new user, I was wondering if there are any available discount codes for the self-paced core class?
-
What does your university use Smartsheet for?
I'm curious to know how other universities are using Smartsheet.
-
Higher Education focused virtual user group tomorrow! Link to Register
Higher Education focused virtual user group scheduled for July 30, from 10 - 11 am PDT You can view the registration page here. Please join us for this virtual user group to explore how Morgan State University leverages Smartsheet to optimize work, accelerate timelines, and maximize impact within the Office of the…
-
google drive integration storage best practices
We are an enterprise higher ed group familiar with Smartsheet, but new to using the Google Drive integration. We are (hopefully) transitioning our documentation processes away from clunky word docs into the more automated Google Docs direct from our project register as work requests come through. I've gone through the…
