-
MS Teams Error when Adding Sheet to Channel
Hi there, I'm receiving an error when trying to add a sheet into our teams channel. I have no issues connecting to smartsheet within teams and selecting my desired sheet to add, but when I select the publishing and access options, then click save, I immediately get an error. See attached screenshots (Pic 1 is selected…
-
Automated workflow not working - Status change
Dear Smartsheet community, I am trying to implement a simple automated workflow, which should work in the following way: If I put to a cell in column "Progress" the value 100%, respective cell in column "Status" should automatically change to "Done". What happens: 1. When I run the workflow, it changes every cell in column…
-
Move a cell in the same sheet and make it a sub-task
Dear Community, My primary column is a Project Name. There is also a column called "Location." My objective is to add a new line (manually or through the form) to the sheet and then let Smartsheet sort it and put it together with the other lines with the same locations. I would also like to make it a sub-task to the first…
-
Allow date in cell but only when all other cells complete
Good morning, This question may have been asked many times, so apologies if so, but is there a way to stop a user entering a date into a cell until all the other cells in that row have been completed and filled in. This would then stop the row being moved to another sheet partially complete, because that cell is the…
-
Display all rows in the request update email notification
Hi all, I'm trying to solve a problem with incoming notifications. When an Update Request email is sent to a colleague, it displays only first few rows and "+32 more fielsd" info. Previously all lines were displayed in the received email. It is possible to change it...some way so that all fields for editing are already…
-
Are rows limited to 20,000?
Hello, I am currently transitioning some of our Google Sheets spreadsheet tools to SmartSheet in an effort to work collaboratively with a partner of ours. One of the essential components of our tool is a spreadsheet which we use for value lookups via the vlookup function which has about 250,000 rows. When trying to upload…
-
Can't logged in Data entry page
Report ID 4679298771642244 has been blocked due to an error.
-
Multiple Sheets
Hi All, I have created multiple sheets and assigned different individuals to carry out their tasks in their own sheet. While I have set up the automation separately in the back of each sheet to move rows once certain criteria are met and move the sheet (Job) on to its next stage and next employee. I would like my original…
-
Purchase Order form with multiple line options
I'm creating a Smartsheet grid with form that will generate a purchase order. There will be an option to add 9 different lines to the PO. Each line has its own variables: Quantity, Unit, Unit Cost, and Description. I added a question "do you have additional items to add to this PO" as a column with logic to have it either…
-
Aligning Columns in a Report that is pulling Data from Multiple Sheets
I have a Primary Column in two sheets with the same data - Project IDs. The subsequent columns are different, however. One sheet has team members info. The other sheet has budget info. Can I create a report that pulls from both sheets, and the Team Member info is side-by-side with the Budget information? As I understand…
