-
Fix Errors Due To Managed References Within Collections
Sheets/reports within a Collection that have managed references to sources outside of the Collection will fail with errors for those formula cells. What's the point of Collections if you can't pull source data into it from outside the Collection in Workspaces you don't want people to have access to? I didn't have this…
-
Changes over Time - COUNTIFS?
I have a project where a group of users can submit a smartsheet form at any time to request a new enhancement to one or more of 3 tools. One of these tools is managed by an outside vendor and therefore management wants to be able to track number of enhancements submitted to them as well as how they progress through status…
-
Control Centre push an update to all provisioned worksheets
I have a large number of assets that have been provisioned through Control Center. I want to install a formula in one cell in a specific column. I thought I could update the template in the source folder of the blueprint and publish it, however, that functionality has been removed or I can't quite figure out how to do it.…
-
Auto Check a box after 24 hours
I have tried to get smartsheet to auto check a box 24 hours after a row is created and column "Task Started" is not checked. =IF(AND([Task Started]@row <> 1, TODAY() - Created@row >= 1), 1) This returns #UNPARSEABLE. Any help would be appreciated.
-
Copy Parent Issue Key (link) into Child Row as a link
Hello! I am trying to pull the issue key link from my parent row into the child row. I have used the formula =PARENT([Issue Key]@row ) But it returns the text only, not a clickable link. Any ideas?
-
How to include start/end times (hh:mm) in addition to dates?
I’m building a detailed cutover/go-live schedule and need both date and time (hours:minutes) for each task’s start and end. The standard Date column type only records dates, which isn’t sufficient. I’ve read in a few places that Smartsheet has rolled out a Date/Time column type, but it doesn’t seem to be available in my…
-
Multiple Forms - Add info to existing row
Hello! We work with a registration form that feeds a master sheet, we want to add another form that will update or add a request for change for a registered contact, but we do not want to generate a new row, we want Smartsheet to match the name or ID to the initial registration and update the columns. Do we need a formula…
-
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…
-
New to formulas: auto creation of + or - 4 week visit windows
Hi, I am new to formulas. If I have the initial visit date in one column, I'm wondering if there is a way to have actual dates inserted in preceding columns based on the initial visit date: 1 column showing the next possible visit date +X week or days date max and then in another column the -X week or days date min. Is…
-
Assistance on Calculating Target % Complete & Understand %Complete calculation
I need assistance with understanding how the % Complete for parent tasks in Smartsheet. Specifically, I’m trying to understand how Smartsheet computes these percentages at higher hierarchy levels when using formulas. Even though the Actual%Complete and my calculate column of "Developed %" values for child tasks are…