-
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?
-
Recurring Update Requests until task is complete
I have a workflow where a contact is sent an updated request when they are added to the row. What I would like to know is how to have that update request sent regularly (daily, or weekly) UNTIL they have submitted the update request. Then I don't need them to get the update request anymore. Is there a way to do that?…
-
Traffic Lights/cell colour based on corresponding numeric value
Hi, can anyone please help? I want to set up an alert system in SmartSheet that turns a cell green (and labelled 'on track') if a corresponding cell is >90%, yellow ('needs work') if 70%-89%, orange ('at risk') if 40-69%, red ('behind') if 2-39%, and blue ('not started') if <2%.
-
How to Cross Reference Data from Another Sheet
I'm trying to link data from a column in one sheet to the similar column in another sheet. What is the best way to do that? I can't seem to get the VLOOKUP formula to work properly. Thank you.
-
Moving Contact Information from SharePoint to Smartsheet
I'm trying to setup a Microsoft Flow to move data from a SharePoint list to a Smartsheet. The problem I'm running into is that the Contact column type in Smartsheet won't accept the "Person" column type data from SharePoint. I continue to get this error: Value is not supported for this column type. Use objectValue instead.…
-
Assigning tasks through forms
Hi, I want to create a form that limits the selection to unassigned tasks from a master task list. The task columns is currently the primary column, so there is no limitation to create a drop down menu in the form. Is there a way to limit the options in a form with a filter? Thanks!
-
Auto-Refreshing Sheets/Grids - to auto update formula cells.
I saw a post in the community at https://community.smartsheet.com/discussion/auto-refreshing-sheetsgrids which had a similar question. But no answer was provided and the last update (from another member) was in Dec. 2018. Again, no response or answer was provided. I have a sheet, with formulas, to calculate today's date,…
-
Link to another sheet and add additional days
Hi there, I am trying to link to a master schedule but adding some additional days to define my drop dates. Please help. Thanks.
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…