- Is the Email Notification highlight color yellow definable?
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
- Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
- Flexible Date Formatting
I have discovered 27 distinct methods for formatting dates, not including variations in separators. Unfortunately, Smartsheet only offers 10 date format choices. In the IT field, aligning data with its intended use is crucial, and proper date formatting plays a significant role in multi-factor authentication. If a user…
- Using Multiple Forms to Update a Single Row
Is there a way to use multiple forms to feed into a single row? An example would be our orthopedics program. Our coordinator collects several pieces of information from multiple departments (OR, Pre-Surgical, Med/Surg Nursing Floor, Education, etc.) Can I build something so she can create a row per patient with their ID…
- Salesforce Connector Requirements
Does anyone know if there are version requirements for Salesforce to utilize the connector? My IT team is about to upgrade SFDC to Lightning and they want to know if the connector works / requires lightning.
- Healthcare staffing templates?
Hello, I am very new to Smartsheets, and I would like to know if there are any healthcare templates that we can use for our agency. We track referrals from the sources. We monitor the status of the referral based on the clinician's acceptance to treat the patients. So we input a lot of data, which sometimes can be…
- WEEKNUMBER and WEEKDAY
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…
- Multiple Critical Paths in Single Project
The last task/activity in my project plan is not the "end" of the project, or at least not the end that we care about for reporting purposes. I work in pharma, and our project sheets are tracking toward their NDA submissions, which is the "end" of the project that everyone cares about when it comes to executive reporting…
- Modifying a date based on 2 variables
大家好!我想创造a formula that says If the value in the "Variable" column is "HIGH" AND the date in "Column 1" has a year less than today's year, return that date with TODAY"S year. Otherwise return that date unchanged. In other words, dates in the previous years are brought to this year, dates in…
- Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…