-
Get a date from the the newest modified column of another sheet both need to have same ID
First Sheet *Service Ticket ID *Estimated Finish Date <---With formula to be pull from second sheet Second Sheet *Service Ticket ID *Estimated Finish Date to be entered manually *Modified Date (System Colum) I'm trying to create a Formula that will be placed in the First Sheet (Estimated Finish Date), this Estimated Finish…
-
Formulas are displaying #INVALID VALUE after form submission
Good morning! I have developed a system in Smartsheet that tracks production efficiency for 40 different workcenters. This system has been working as intended since Sept 2021, but beginning on the afternoon of Tuesday the 12th something broke on some of the sheets that drive the system. I have a formula to turn the…
-
Organizing Folders and or Workspaces that work for non linear brains... Dyslexic and ADHD
I don't store most of my work (copies of invoices, important emails, inspection reports, work orders, parts diagrams, etc) in a typical folder, subfolder or nested folder system. To me, it is a blob of letters and numbers when searching for anything. I also don't have a brain that can go to my desktop and find an icon from…
-
Is there a way to RECONNECT a form field to a column in the sheet? Feature Request?
So here's the scenario: You build a form and it creates the sheet automatically. Then, for some reason, you accidentally delete a column in the sheet. The form field still exists, but the column is gone. You recreate that column exactly like it was in the sheet, however, now the two are no longer connected. It'd be great…
-
Word Count Limitations?
I am setting up a form but need to limit the word count. I already built a formula in the sheets with formatting to identify when an entry has surpassed the 1,500 word count max but I want to limit it while someone is filling out the form so that I don't have to send it back for edits. Is there a way to limit the word…
-
How can I change dropdown values from text to number in forms
I have dropdown values as numbers like below However when the form is submitted, they look like text When i manually change them from gridview, they are in number format
-
Sharing Permissions - Workspace + Reports
Hello Smartsheet Community! I am having a heck of a time trying to find the right combination of permission levels to share Reporting. We need to share the source sheets that the reporting is pulling from. We don't want these users to be able to "edit" the source data, but we do want them to be able to filter the Reports…
-
Live copy of datasheet
Is it possible to make a live copy of a datasheet. When new rows are entered on the original, will the copy update? I also would like to add additional information to this copy, but I don't want information I entered on the copy to affect the original.
-
2021 Core App badge
I received my 2021 Core App badge through Credly on March 25, but it still isn't showing up in the Smartsheet Community. When does that happen?
-
IF, THAN, ELSE statement
I am needing to create a formula and I am stuck. I have 3 columns, "PO Cut", "Completion Date" and "Number of days" What I am tying to do is have the "Number of days" column show how many days have passed since the "PO Cut Date", unless there is a date value in the "Completion Date" column, then just calculate number of…