-
Add Centralized Date/Time or Changeable time zone on System generated columns
Please use UTC or a changeable time zone for columns which are system-generated. I have a sheet where I transform the "Created" column which is in UTC to a date in EST for readability. The discussion user however is in PST. That changes the "Created" column which in turn changes the transformed column. Normally, this would…
-
Stuck on a COUNTIF formula to use
Hi all I'm still trying to get my head around Smartsheet formulas with mixed success, many times i try to use the AI formula creator but it often fails for me… Im trying to create a formula that addresses the below AI query that keeps either returning an #Unparseable error or #Invalid Data Type. Basically, in my sheet i…
-
Disable License Request Features
Ability to disable user license request functions within the Enterprise Admin Console so unlicensed users cannot request licenses through the Smartsheet dashboard.
-
Smartsheet Consultant / Specialist Available
Hi everyone, I’m currently available for new opportunities and projects. I bring 10 years of experience with Smartsheet, including most premium apps, with a focus on: Building and optimizing solutions (dashboards, reports, workflows) Automations and integrations (including API work and Bridge) Data aggregation and…
-
Data Shuttle Not Recognizing Excel File Saved Via Power Automate
A colleague has Power Automate set to save Excel files (.xlsx format) to a standard SharePoint location each night. The files have one tab each, are consistently named, and have no extra rows. Data Shuttle will not recognize the Excel files unless they are manually opened and closed. No change is made—literally just opened…
-
How to contact SmartSheet if an account is blocked?
One of our clients is getting an error when logging into Smartsheet: "Access to your account is blocked due to a billing issue. Please submit a ticket." -When we try to submit a ticket, it doesn't go through. -When we try to contact support from the website, it always asks us to sign in, which we can't do since the account…
-
I did a "Save as New" on my sheet and the new sheet is missing all the Proofs. How do I get that back?
Hi All, I thought I was being smart and did a "Save as New" to my Smartsheet to preserve all the information on all my rows and create a "Completed Projects" sheet. Then I deleted the open project from the newly created "Completed Projects" and then deleted the Completed projects from our main sheet. I noticed this am that…
-
Allow Manual Adjustment of Row Height
Excel has this functionality and it is invaluable for managing the display of data in sheets. Just because I have a lot of narrative information in a cell does not mean I want to have it all visible all the time when in the sheet. Often it is more valuable to see more rows than to see all the information in a cell at the…
-
Logic for If this AND if that then....
Does Smartsheet have the logic capability for me to ask it "If Column location is East, AND Column Credit request is travel credit" then use the standard default amount of $500 in travel credit amount column? Basically, I want to add logic where the answer displayed is based on 2 columns and not just one.
-
Renewed License but Unable to Edit Smartsheet
Hi, Our team has just renewed our Smartsheet license after the trial period, but we are not able to edit or enter data. What can we do to be abe to edit and enter data again? Thank you.