-
Parent Row formula for Max date + 540 days
I'm trying to use a formula in the Parent row of several date columns that will: 1) give me the MAX date from the child (anywhere from 1-12 rows) 2) add 540 days to that date (from #1) This will work using: =MAX(CHILDREN()) + 540 Except if the child row is blank and then I get the error message #DATE EXPECTED I've attached…
-
If and across sheets.
I am trying to write a formula that looks on another sheets row for an employee # and for a task code and then return the proficiency level linked to that task code. For further info I will try to explain my thinking. A trainer submits a form stating the employee #, SOP, and Competency level, to a sheet called "Training…
-
Need help with IF formula
Hi All, I've looked everywhere with a similar issue but nothing comes up. I'm trying to create a column where the cells auto-populate a facility name depending on the territory selected in the territory column. I'm assuming I need to use =IF but tried various ways with no luck! I've included a screenshot below to hopefully…
-
Show Conditional Formatting/Cell format on Automated Alerts
I have built an automated alert that determines which columns to include from a large Smartsheet which uses the max 200 columns based on a number of parameters held within certain rows on the sheet. This works well. However the issue I have is that I have conditional formatting contained within certain columns in the…
-
Feature Update Request: Kiosk Mode for Dashboards
Smartsheet dashboards are just begging to be used as a kiosk. A rotation between a list of user specified dashboards showing different KPI's, and a home dashboard that is navigated to upon any user input would be amazing to have, and I would use it throughout the facilities I work at. I am able to obtain this functionality…
-
Reminders - Single reminder per row same date same recipient
Hello Folks, I have a Smartsheet with many rows that have reminders for different tasks. Some of the rows / tasks are set to send on the same date to the same recipient. When this occurs all of the tasks are combined onto one reminder email to the recipient meaning one email with many tasks. I have been asked to look at…
-
Routine reminder
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflows but if I can combine let me know. I am also trying to find a way to not have to…
-
Entering values into a contact column
In my dashboard reference sheet, I have a contacts column. Under this contacts column, after the table with the contacts, I have linked data from another sheet for another purpose/widget, and this works great. I am trying to grab information from another cell in this same sheet using this formula: =[if COMPLETE]28 under…
-
Can I delete rows from Master sheet?
Hello, I have a Master sheet, into which information comes every day via a form. I also have a Wrap Up sheet which pulls specific data from the Master and manipulates them via a formula into a number I need to display. For example, the form populates the Master Sheet with the number of patients on a unit at midnight, the…
-
Sign-in Sheet using Smartsheet & Forms
I have built a sign-in sheet using forms (yay) but am now wondering if there's a way to do the following: We occasionally collect some attendee data that I'd love to have pre-populated so that people can sign in and add in the rest of their information and also sign there. Is there a good way to do this in Smartsheet?…
