-
Nested if()
Hello great community. I'm new in Smartheet and I've a problem and even don't know if a solution exists. I'm trying to create a sort of automatized timesheet for my team. I would like them to connect to the same sheet. They have to select their name in a list ("Team" column), and the type of mission they've managed in an…
-
Mandatory text to activate checkbox
I have a "Notes" column that requires text before the checkbox under "Req Attn" will be checked, kicking off conditional formatting in other columns. I found this thread and tried to implement the suggested solution: https://community.smartsheet.com/discussion/formula-help-if-cell-blank-checkmark-cannot-be-checked I…
-
Automating the addition of a task list to a sheet
My department is working on a change management process, the steps of which will be standardized for each change. We're using a web form and alerts to notify the team of a new change request, and managing the workflow with a separate sheet. Is there a way in the workflow sheet to populate the list of tasks without having…
-
Combine single sheet in master sheet
Hai all. I need to combine 6 individual sheet into one master sheet. Then need to see all the detail. each sheet have about 120 line item. can any one help.
-
Suggestion for dynamic lists
A feature that would be fantastic for large scale project work would be dynamic lists that could be set up on a sheet and then referred to by drop-down lists in other forms/sheets. E.g. As more projects or names are added to a sheet these then automatically populate drop-down lists for an "Add new risk" form.
-
See projects rolled up in a program gantt
Apologies in advance if this has been answered before - and I imagine it must have been since it seems a very obvious and primary requirement for managing projects in a business. Still, for something this fundamental I just can't understand why I can't see anything in the solutions centre or a search here in the community.…
-
Identify duplicate dates and exclude blank cells
I am working with a SmartSheet that is used by multiple people to schedule meetings. I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)". Dates are entered in rows 7-28. I have added a checkbox column titled "Duplicate Date" to be checked if a…
-
Populating a Second Sheet
I have a form created for a sheet so that when it is submitted it adds a row to Sheet 1. How do I have a second sheet recognize that a new row has been added to Sheet 1 so that it can pull data from a few of the columns? Thank you, Matt
-
Index or Vlookup or What?
Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match…
-
Best way to export a Dashboard?
Print view looks terrible, especially when we have an embedded Calendar view widget it shows up blank. We have widgets: - Report - Shortcut link to sheet - Calendar view We would like to "back up" the dashboard view to PDF or image format and attach it for those that want to view offline (and back up in Dropbox).