-
Solution Spotlight- Healthcare Capitol Construction Demo
Hello all! Our Commercial Solution Engineering Team is hosting a demo of a capitol construction solution on June 25th at 11am PST. Here is the published Smartsheet Dashboard if you are interested in registering! If you can't make it, but still register, we can send out the recording. We also have a special guest, Neil…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Is there a way to format numbers from decimal into fraction like excel does.
I am in construction and the need for fractional formatting is very important. I have seen other community questions from 2017 regarding this but has not been updated. Will there be an option for the formatting soon?
-
Excel @Text() Functionality in Smartsheet?
Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…
-
Managing complex, multi-sheet schedules
We are building a large multi-family project. We set up our schedules to be broken out by building permit shell and units. There are 99 sheets in total built using the standard project template with some customizations. Our plan was to roll up these sheets into reports that would allow a project manager to easily update…
-
Smart Forms Templates
Is there any Smart Forms Templates that can be used? I wanted to make a smart form that allowed the easy use of Contractor SOW form or something similar to it. I wanted to be able to have contractors fill it out and state their information such as, certifications relevant to work being completed, personnel on site during…
-
COUNTIFS/CONTAINS FUNCTION
Hi All, I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, "In Progress", {CORP ADMIN TEAM TASKS Range 2}, "Jane Doe") However, it is only…
-
Duration and Date Dependencies - Reference Cell in Same Sheet
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm trying to have the information in the Project Summary cells pulled into highlighted durations/dates so that it doesn't have to…
-
Project Collaborators Schedule Report
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…
-
Automation using reference cell
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this monitoring is measured as the stages are marked as Complete. This calculation is straightforward with a formula that…