-
Why did your support AI bring me here to cancel my subscription?
Your AI bot shared with me when I asked for support that I could not access a live human or email address and recommended I go here since I don't have the privelege of support. Can someone from SmartSheet please contact me by email so that I can cancel duplicative recurring charges on my credit card that you are charging…
-
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,…
-
Index, Match formula returning some, not all values
Formula was flowing correctly, but some change seems to have partially broken the pull but I can't figure out what/how. "Project" column dropdown is linked to a Master sheet. Budget Owner column contains the below formula which should look for the cell value in the Project/Cost Center/IO column within the P+CC+IO column of…
-
Seat type automatically changed from "Member" to "Viewer"
Hi Everyone, Is something going on with smartsheet. For some users in my organization, the seat type has been automatically changed from "Member" to "Viewer". Additionally when I raised a support case, no one has been assigned to it yet.