-
User attachments
Hi, My team members are unable to attach files under the Individual Plan. According to the Smartsheet features attached, I should have this feature on my plan. Thanks, Kyle
-
Getting Status of Children to roll up to Parent Row
I have Parent tasks with Children tasks in a dropdown list column. The options for the children are: assigned, in progress, complete. would like to have the parent status display be blank if none of the children have a status selected (all are blank), display "Complete" only if all the children have a complete status,…
-
FILTER
Hi, Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report. I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all…
-
Alert Email Triggers a Checkbox
Hello everyone! New to the community, but loving how detailed Smartsheet is! I am setting up alerts to trigger when a due date is approaching, 6 months, 3 months and 1 month to staff whose certifications will expire on that date. I would love for the alert to trigger an additional action, to check a box in the cell…
-
Capture date when row changes
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "animating" - start date needs to capture the date(fixed value) it was changed to "animating" 2. When status column changes to…
-
Vlookup woes
I'm trying to do a VLOOKUP and am getting the result #NOMATCH for all entries. Essentially I want to look in the Instructor column in Sheet A, check Sheet B and find the Instructor name and return their ID number. The Instructor names are in the first column of Sheet B, like they're supposed to be, and the IDs are in the…
-
If statement % complete column
I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date.
-
IF and OR Formula
Hi, I am trying to write a formula that returns a flag if one of column 1,2,3,4,5,6,7 isn't checked. I have tried using the IF and OR formula together but am getting #Unparseable. Any ideas/help will be appreciated. Thanks
-
iOS app allows editing of some dates but not others
I’m traveling this week and only brought my phone and tablet. I downloaded the app assuming I’d be able to use it to edit my schedules, but for some reason some date cells are editable and others aren’t. As luck would have it, the active date cells are the ones I can’t edit, the “planned” date cells, which are permanent…
-
Rich Text Widget
Can text only be entered into Rich Text Widget in edit mode? I was hoping there's a widget that we can use to capture notes live in a mtg when reviewing the dashboard. Suggestions?