-
Removed? - Escape the Sheet: Solve. Build. Break Out.
I was really excited to do this fun Escape Room themed session. Was this removed from the conference? I can't find it on the app, though it is still showing on the Agenda via the website.
-
Sequence numbering based on another Cells info.
I'm looking for a formula to sequence document numbers based on another cells info. I've set up IF functions to code each main column (in blue) which will be hidden in the background & locked to which i then used a JOIN function to get a serial code. (shown in "document Code"). With those in place, On "Document No." Column…
-
Problems automating and matching with formula
Hi, I have a formula that used to create an order number, composed from the following fields: The date date + an auto number, then the "/" character gets removed. Our vendor also uses Smartsheet. I have an automation set up to send the information over to the vendor, but it doesn't transfer right. It consistently transfers…
-
Contact List matching
Hi, I have been struggling for awhile that the contact list in a sheet, including automation, doesn't sync with My Smartsheet Contact list…how do I edit the contact list in a sheet? TY
-
Checking a column for a single cell that meets all conditions
I have a form that has two multi-select columns and I am trying to find a way to create a chart out of the results. The two multi-selects are "Name" and "Food Given" and then a column for the number of days since the food was offered. I want to take those results to another sheet and have it determine if each critter can…
-
Totals and calculations in forms
allow users to add section to request amounts and total them something like: blue widgets needed - # red widgets needed - # green widgets needed - # Total widgets = # blue+# red+# green
-
Sum cells from a reference sheet based on a range of dates
I need this formula to sum cells in a reference sheet based on dates. The reference sheet has a column with dates, and there could be multiple of the same date. I was able to get this formula to work on the top line in the screenshot, but the next line is adding the 2 week ending sums together. The planned bushels for week…
-
Best way to manage multiple users
Hello, The company I am with has an enterprise license for SS. We have a task where we are storing updates on a spreadsheet, as they evolve, within multiple departments. This has created much discrepancy within the data. I would like to lock it down to about four people being able to enter updates while others submit…
-
when the original owner of a workspace leaves
My company is new to Smartsheet - we have been using it for about 2 months. The person who initially set it all up for us has since left the company and his account has been deleted from smartsheet. However as his name is still present at the top of the workspaces I guess that means he is still the listed owner of the…
-
Auto messaging
Hi All I have created a support request form and sheet to allow functions to request support from my team. When a request comes in, it is assigned a unique support ID number. I then assign the request to a member of the team vias drop down. I have added an automation to message the requester when a team member has been…