-
basic formula im sure, but Im new to this
I am trying to write a formula that says the if the end date is before today that it selects the "Late" option out of the drop down in Status. I got most of the way there but keep getting an error. HELP
-
Need formula to dynamically populate multiple rows from cross-sheet reference
I need to create a sheet that dynamically displays all projects assigned to me from another sheet called "Project Request Intake & Validation." Requirements: The sheet must update in real-time (if a project is removed from the source sheet, it should disappear from my sheet automatically) Each assigned project should…
-
Timeline View: Center on Today with Options for Visible Date Range
Timeline view is great. It has become our new favorite. One drawback is that it currently opens with the blue line (indicating today's date) way off to the left. Most of our projects have been in play for some time, and we like to see full bars in the visual, from the Start Date to the End Date. To accomplish this, we are…
-
How to Cascade Task List Updates Across Multiple Workshop Instnaces
We run workshops multiple times per year (e.g., quarterly). Each instance uses the same task list and are all on the same worksheet. If someone updates the list for one quarter (e.g., adds a new item to print) they have to manually update the list for every other quarter. Is there a way to cascade updates so that changes…
-
Calculate percentage based on drop down response from one cell and value of another cell
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
-
Free Collaborator User Bulk Upload - exclude Premium Application
The concern is that Free Collaborators should not have access to premium applications. However, during bulk uploads, premium apps are still being added. There is an option to 'Edit User Properties in Bulk', Furthermore, removing premium apps through 'Edit User Properties in Bulk' is only possible after users accept their…
-
How to calculate the % of complete activities under each parent row.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
-
Merged: Workspace Folders
This discussion has been merged.
-
Multi-Print Functionality
Currently Smartsheet only allows for one sheet/dashboard/etc. to be viewed and printed at a time. This requires users who may want to print multiple sheets/dashboards as a single document to access each item individually, print to PDF, then consolidate each individual PDF into a single document, all as separate steps. This…