-
Board View card order
We're running sprints every 2 weeks and have a lot of cards in each lane in Board view. I manually set each card in a particular order from top to bottom in each lane since there is no current Sort option. Randomly, Smartsheet will re-order the cards! I can't figure out why they are getting re-ordered, what is causing it,…
-
Power automate insert row not working using dynamic Sheet Id
Hello - I am trying to use the Insert Row Power Automate Smartsheet connector and it works when the sheet ID is static/hardcoded; however, I need to be able to pass in the Sheet Id from prior step. When I change from static Sheet Id to dynamic, all of the sheet column fields go away. The problem I am having is formatting…
-
Multi-factor Authentication
In order to mitigate password vulnerabilities and attacks, please add multi-factor authentication to Smartsheet. It's a security best practice and most SaaS applications (such as Smartsheet) already has this integration available.
-
Linking sheets - Trying to build off of information from other sheets
Hello! I am pretty new to the intricacies of the platform as I'm looking to lead some project management and automations for the organization I'm in. I have a sheet I am trying to build Automations into, but would like to see if anyone can walk me through how to link this information from other sheets, as they get updated.…
-
Pivot Table using Sheet Summary Report
Hello, I need to create a Pivot using a Sheet summary report as the only source file. When I go to the pivot builder I do select my report as a source, but once I move to "Assign Columns" I am not able to select any row / column / Value to populate the Pivot: if i click on "Add Field" it always shows "Empty" (which is not…
-
Planned vs actual progress (Summary level)
Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula =ROUND(IF(TODAY() < [Baseline Start]@row ,…
-
Control center: include template(s) based on value in Intake Sheet
In control center is it possible to set up so that template(s) is included during project creation based on the value in the cell on intake sheet?
-
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
-
Add columns to Reports from multiple sheets
Add columns to Reports from multiple sheets with extra calculations that we can leverage for some reports that we dont need the columns in all the sheets feeding the report.
-
Nominate Peak Humans & get a badge!
Hi Smartsheet Community, We loved learning about what operating at your peak looks like for you, and now, we want to give you the opportunity to recognize and celebrate others, and earn cool badges as you do it 😉 The Operate at Peak Human campaign is a celebration of humanity. Recognize someone who does a great job in any…