Release Scheduling - Create a Dynamic Release Drop Down
This use case allows business customers the ability to request support, based on a weekly release window. Future support may be reserved. The release day is every Tuesday. For reporting and counting purposes, I don't want to provide the user with a date picker. I want to drive the # of weeks per year and the corresponding…
Drop Down List not populating (Mobile Version)
Hello i have a quick question and was wondering if anyone was experiencing similar issues and have found a work around. I put together a checklist for our MHE and would like to post a QR code to the Smartsheet around our facility. The issue i am experiencing is one of my columns with a drop down box is not populating on a…
Dashboard Data Filtering
Hello, I have created a dashboard that collects results from a scorecard that is designed to be filled out by periods (12months), quarters (1, 2, 3,4) and year to date. Is it possible to create a filter on the dashboard where you can select to view information being displayed by either the period or quarter? If yes how…
Formula Help For Multiple Tags Within The Same Cell
Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the instances of a specific tag. For example, the intake form allows multiple 'characteristics' to be chosen when describing a call. These…
Quality controlling data entry to prevent duplicates
I have a vendor database with over 1,000 unique vendors and am looking for a way to quality control new entries to avoid duplicates in a VENDOR NAME column (note that there is a separate VENDOR ID # column). One way of doing this seems to be through formatting the VENDOR NAME column as a dropdown while NOT restricting to…
Create an alert when there is no activity in the sheet
If there is no activity in the sheet in the past "X" days, we should be able to create an automation to alert someone. It is really important for the sheets that are updating automatically so if the automation is broken, the user can be notified,
Calculating how many days passed (between 2 dates)
Hi All, I am wondering if you can help. I have a very basic formula in place to calculate how many days passed from date 1 to date 2. I used NETDAYS formula. Since we use it to calculate the time from when the issue was raised until it was resolved - the end date is not always there straightaway which of course brings back…
Extract text from a file string
Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents/Training/Investigators/Rhodes, Meredith/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…
How can I convert a Local currency to USD in the Smartsheet Form.
If I need to convert the local currency to USD in the Form, Can I do that? For example, if I fill the THB2000 in some field in the Smartsheet form. Then, I need the form to automatically convert the THB to USD. Is it possible to do that.
Calculate Total Completion
Hi. I am still learning smart sheets and have a very simple sheet that is tracking the completion of a project that I am working on. I just to have an automated completion total of what is checked off vs what is not checked of in my Completion Column. Please see image. Please and thank you.