-
Error: There was an error submitting the form.
I am getting an error when I submit the form. The error says " There was an error submitting the form. Please try again. If the problem continues, contact the owner of this form". I have checked the automation and all the fields with logic. They all looks fine to me and earlier everything was working. Today, when tested…
-
Update data in one sheet from another sheet that updates daily?
Hi there, I have separate product sheets (70 of them!) for each product a division creates. Each row in the sheets has a unique line item number. The first 23 columns contain data pulled from one of our systems, including the line item number. The remaining 26-40 columns contain data that's managed manually. I have another…
-
Charting Text Dropdown List
Hello, I want to visualize the 4 options in a chart showing the percentage of each one. Also, I would like to show the same percentage for the 4 options within the sheet. I would like to know if one formula is an option or if I must create a column per option. Thanks in advance.
-
Control Center Global Updates
We are now using Control Center to provision projects and as we are learning how to use it better we need to keep doing some updates to the templates and the existing projects we have already provisioned. I have been using the Global Update feature, but when I use it to update a Dropdown list in a Dropdown column, the…
-
Need help calculating estimated completion date for production while excluding weekends
Hello Smartsheet Community! I have a project I am working on for work, and I am struggling with a formula to calculate the expected date of completion for our production orders based on a few criteria. A few things are missing that are confidential, but I have attached a picture of a practice spreadsheet: Please note: a…
-
Merged: Allow Customisation of the Limit for Latest Comment
This discussion has been merged.
-
Formula to show duration days in Months, Weeks, and Days
I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…
-
Formula to Change Symbols in Column Depending on Review Status
Hi all! I'm working on adding a formula to a column to populate status symbols in another column. I've attached an image of the sheet for clarity - I would like to display the symbols in the 'Director Approval Status' column, with the original dropdown selections listed in the 'Director Approval' column. Here is the…
-
Form Filler
It would be cool if instead of going from form to sheet it could go from sheet to form. I send out a lot of paperwork that if I could just populate with the info from certain columns, it would save me a lot of time or at least give me a fairly complete first draft of the paperwork I need to send out.
-
Smartsheet not saving consistently
I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time when I return to a given Smartsheet, data I added or changed is missing, did not take. This doesn't happen…
