-
The sheet that you are attempting to access is no longer published
Hi all, We are getting this error message on smartsheets today, sheets that are used regularly throwing up these messages. Once you click accept and continue it's ok but any ideas as to what is causing this?
-
Digital Signature
Hi all, I've searched for this topic, but i could not find directly what i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solutions i saw were about using another software to do it, but those were from 2017. I am just…
-
CountIFs formula question
Hi, I am trying to count the amount of time a drop down is selected within a range of columns that is in a specific location (separate column with it's own values). My goal is to count how many times Location (A-C) have the value Properly demonstrated and Not Properly Demonstrated selected. This is currently the formula I…
-
How to attach notes to a line item
Hi, I need to attach notes to my line items. Setting a column as a Note Field is not practical, as I have too much informaiton than can fit on a short line. Using Comments is not practical, as I need to be able to easily access and edit the notes, not scroll thru a list of Comments. How to achieve this in Smartsheet? Thank…
-
Can I turn comma separated lists into multiple-choice dropdowns?
The title basically says it all. I have a column that was built in Excel, with multiple items separated by commas (no spaces) to make a string of about 1-5 items. We're moving our processes into Smartsheet, and I want this information to be formatted as a dropdown column with each item chosen as a separate entry.…
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
"Live" source template sheet
We have projects running with long and complex workflows and thousands of tasks - so we need to break these down into multiple sheets (dozens), and then use reports to extract data from tasklits to time-tracking and budget burndown. However - if we need to change the structure or components of the sheet in any way ( extra…
-
Can I use global update on a sheet template's form?
I would like to do a Global Update in Control Center on a sheet template's form. This will allow me to update the form on a specific sheet in 70+ projects very efficiently. My worry is that this functionality is not available and instead I will need to go into each project, find the specific sheet, and manually update the…
-
Booking calendar appts
has anyone created a booking calendar? this will allow users to select an available appts by showing the appts that are open. Similarly to how the calendarly app works
-
Sheet property information?
I just ran out of cells in a sheet and needed to fire fight to recover some data that pours in via an automation. Generally I don't need to create a new sheet until year end each year, but this year saw an uptick in line items. Is there a way to collect high level property information from a sheet?I was envisioning…