-
Match Statement with Multiple Sheets
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO") I have another sheet…
-
Approval process form with custom comment field. NOT THE GENERAL COMMENT FIELD.
Good Morning all, I established an approval workflow with a loop by using this: https://community.smartsheet.com/discussion/how-loop-through-workflow However, i would like to track the comments of the Approver for example. Sure he can insert a comment in the general comment field but i would like to have a field only for…
-
Conditional Formatting based on system columns (Attachments and Comments)
I can't find any discussions on this. I'm looking for conditional fomatting based on two of the three System columns: Attachments and Comments. These are not available today when trying to add conditional formating to a row. For attachments, I would like the criteria based on: - Changed: If the list of files has changed at…
-
HELP ON FORMULAS
I am trying to create a formula that will change the production status automatically. My [production status] column is a drop down box with these options "Roof Ordered, Roof Delivered, Roof Building, Roof Complete". My other columns are date columns, so when the column [Roof Delivered on] has a date in it I want it to…
-
Losing Data & Slow Performance
Hi, just recently my Smartsheet is going really slow, and I'm losing information I've just entered. I can't drag information from one cell to another, and can take 3 seconds or longer to load information, and half the time the file doesn't actually attach. I have to close down and reopen Smartsheet all the time so it saves…
-
Help with PDF Fillable Files on smartsheet app
I have salesman that use pdf fillable forms for company use. I created a sheet that has all the forms in it as attachments. When using the desktop version they click on the attachment and it brings up the file and they file in the information and can print it. They are unable to do this in there smartsheet app for IOS. I…
-
New comments functionality.
Plain and simple its awful. Actually, to a large degree unusable by our employees and external customers. 1. forced ascending order. does not work for us at all. 2. hitting return on your keyboard - posts the comments. super annoying. 3. "All" comments view. No idea how anyone thought this would be useful. Its confusing…
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Documents not uploading or downloading
Hi All Is anyone else having an issue with uploading or downloading documents to/from their sheets? It is nearly crippling me here as i'm losing important documents as it appears to have uploaded and then it just disappears or won't upload at all. when i click to download, i have to try 2-3 times before the document…
-
Slow in loading the conversations/comments
I noticed ever since they updated the conversations/comments. The panel now shows on the right side instead of the usual pop-up. It's been slow to load. I thought it was just my pc that is slow but any pc I use have the same result. My tablet loads faster for these conversations to load.
