-
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")
-
Added New Sheet and Dashboard in Control Center, But Dashboard Not Added to Project Folder
Following steps from here and here. I added a new sheet and dashboard to my toolkit folder. I updated the blueprint in Control Center to include this sheet and dashboard as Optional. When I go to update an existing project: 1) I click the pencil to edit the project 2) I click the Add New Templates button 3) I click the…
-
Anyone use Smartsheet for tracking legislation?
I work for a state government agency, and this year we are developing a workspace to help the department track bills of interest/impact as they make their way through our state legislature when the next legislative session opens in January. Does anyone have any examples of what they use for something like this?
-
Merged: Retain Document Builder Mappings when Copying Sheet or Creating Templates
This discussion has been merged.
-
Ability to change default background color and background color in sheets
I think the ability to change the background color in smartsheet would be very beneficial in helping avoid eye strain. Most of us are looking at white screens all day and our eyes get very tired and strained. Even with special blue blocker glasses I still notice the eye fatigue. Please consider adding this feature in a…
-
Smartsheet Template
I have created a sheet template from an existing sheet. The existing sheet, prior to saving as a template, had many rows of data The template copies all the data from the original sheet. I only want the sheet layout and formulas. Is there a quick way to remove cell data on the template sheet. I guess better approach is to…
-
Iterative Plan Template
There's an excel Iterative plan template posted on the Smartsheet site. Can a similar template be provided in Smartsheet?
-
Help with #REF
All was good until... Everything was working as designed while setting up PMO template set. Not sure what I did but getting #REF error and would appreciate help in correcting the error . Thank you in advance for your help!
-
Setting up a Program with multiple project
Hello! I am fairly new to SmartSheet and am looking for some advice on how to set up a program management sheet. In short, I have multiple sites which have various tasks I need to track of. I would like to organize by site and task or at least be able to pull a report (or look at a dashboard) that will indicate what is…
-
Combining Sheets
Hello Community! Wondering if anyone out there has any best practices for combining a project plan and a resource plan into one sheet. Is this an option? Would that sheet then be able to have the same functionality and link certain cells / info back into Resource Management? Right now, they are two separate sheets, but our…