-
Is there a way to proactively include the three baseline columns in blueprint within Control Center?
The challenge I'm facing is that these columns aren’t created until the baseline is saved on the sheet—after it's already provisioned via SCC. I’d like to add them to the blueprint template sheet ahead of time so they can be incorporated into my profile data and made available for reporting. How can I do that?
-
Failed to Import (error)
I am trying to import (just blank rows, with 18 columns) from Excel into an existing sheet, so I don't have to recreate the 18 columns into my tracker. But I get a "Failed to Import" error. HELP!
-
Helper Column Parent Rows
Hi! I'm trying to create the helper column to ID a Parent Row so that the sub rows show up in Reports. Right now, I'm using this formula for this sheet, but I get a "No" despite the fact that all the rows have sub rows. any ideas on what I'm doing wrong?
-
Subtracting Months from a date, Error #Invalid Value
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Request Snapshot not received. I am the sheet owner. Not on spam/junk.
I have requested for a snapshot, but I have not received the email yet. Any idea why and what do I need to do?
-
Rows Not Copying with Checkbox
Hello all, I am currently building a dispatch calendar/tracker app for my company. The idea is simple, if any task requires the assignee to be at the location, check the box labeled "Onsite" and the task is copied to the calendar sheet. The issue is, checking the box does not copy the row. If I run the automation manually,…
-
Update Request - Unable to determine your identity
I use update requests to gather information from my stakeholders. Recently, several users have been experiencing an issue of "Unable to determine your identity, therefore we are unable to process your request. An unexpected error has occurred attempting to process your request. We are sorry for the inconvenience." I use…
-
🆕 WHAT DO YOUR DASHBOARDS LOOK LIKE?
we need some creativity from others on some of the awesome dashboards people have created. please share some of the best of the best that you have!! hoping to spark some ideas… here is one of my recent ones - thanks in advance
-
Duration based on time - formula question
I was able to create a Smartsheet column with time included with the date (Thank you @Paul Newcome & @Akblevins ). I want to add another column that just shows the time - I used the AI Smartsheet feature to create a formula but receive an error message. Any ideas on how to correct? TIA!