-
This is a question about multiple selection able to run report and auto counted and group in report
I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in multiple selection
-
Search Automations Capability
I have 150 automations in 1 sheet. It would be great to have a search option or more detailed filters in order to pinpoint an automation quicker. Filtering by automation type (alert, date recording, approval request, etc.), or by person included would be extremely helpful. Thanks!
-
Can we set Request for Update to run only on Business days or based on Business days?
Can we set the request for update to be sent based on business days rather than calendar days? For example, I want the automation to send to staff assigned if no change in activities of the row for x days. We want to set this to be business days instead of calendar days. Would this be possible?
-
How to exclude the dates of a Person's PTO dates from scheduling dates
-
Help with addition to formula
Hi, i need to make an addition to the below formula please. I need to add if column type is issue and impact score is 4 - gray, 3 - red, 2, amber and 1 green =IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 20), "Gray", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >=…
-
Help with IF FIND Formula
This discussion was created from comments split from: How to collect multiple Successor values?.
-
Data Shuttle - Remove row that is no longer is source sheet
I use Data Shuttle to upload current enrollment data for our courses. I have a unique identifier because the source sheet has duplicate entries, but I only need one in entry in Smartsheet. Has anyone come up with a solution to remove the a row that is in Smartsheet, but no longer in your source sheet? Sometimes courses are…
-
Can input from one form separate to two rows when they input to sheets based on conditions?
We currently ask people to select one form per one need for referral into a program. For example, I want to submit a referral to a community health team and another one to behavioral health team. I need to submit two separate forms because each form submission will create one row to master task list where it then auto move…
-
Convert Column to Formula Error
Hi! The following formula calculates just fine in each cell but when I try to apply it to the entire column via the Convert to Column Formula, it's not working: =IFERROR(WORKDAY([Date Submitted to Courseware]@row , VLOOKUP([Analysis Priority]@row , AnalysisPriorityTypeDropDown2:AnalysisPriorityTypeValue5, 2),…
-
Accessing Smartsheet sheets shared with non-licensed users
My company has the Smartsheet Business Plan and I have a Smartsheet license. I've created several sheets and shared them with multiple stakeholders who do not have a Smartsheet license. Some have indicated they are having issues viewing the sheets. I've checked their email addresses, and they are correct. Some are…