-
Open files in a new window
A recent update in Smartsheet changed the way we view files. Previously, when you clicked on a file it opened automatically in a new tab and this meant you could have several files open at once and the ability to move between them. The update removed this function and now the file opens in a preview window with little…
-
CONTAINS formula not working
I am trying to count the number of times the number "1" appears in a range using CONTAINS formula. There can be multiples numbers within the same cell seperated by comma. I have tried doing it via a dropdownlist too but its not working. Hoping for someone to help. Thanks
-
#INVALID COLUMN VALUE error
Hello Community, I'm trying to combine two formulas but keep getting an error. The first formula sums children if it's a parent row or leaves the cell blank. The second look for the most recent data in a row (I have month in the columns from July to June). They work independently but when I combine them I keep getting an…
-
Smartsheet Support Ticket Emails: Include More Details in the Emails!
Whenever I get an email from Smartsheet about a support ticket that was updated, closed, requests more information, or about anything for that matter, it almost never includes important details of the ticket. Easy-to-implement recommendations for EVERY email sent by support regarding a ticket: Include a direct link to the…
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.
-
Submitter (Created By) Showing as Web-Form
Hi -- we have a sheet we are using by sending the link to the form to all employees. They manually enter their email address in the form. The issue is when the form is submitted the workflow automation doesn't work because created by is a web-form. The email from the email address column that was entered by the employee is…
-
Automated Sort in Sheet
Is it possible to create an automation that sorts the rows automatically when changes are saved? For example, if my sheet is sorted by Column "Stage" Numerically Increasing, and I insert a row, fill it in, and save it, I want the sheet to re-sort to incorporate that added row in its proper location. Thank you!
-
contact
I started a Smartsheet trial yesterday. What I really need is to be able to SPEAK to someone personally about this application! There is no contact number available for "trial users". One found on Google does not work. And any email (3) that I was able to find was either unmonitored or no longer active! How can a…
-
Set Target End Date first and have predecessors fill in
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecessor relationships in this row". I've looked into the Workback Schedule using the Project with Hard Deadline and Gantt…
-
Primary Columns in Grouped Reports: change label locations and move column
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…