-
Can Formulas Reference Reports?
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person. When I go to do that and the formula asks me to reference a sheet, I am only…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Can a workflow on one sheet update specific empty cells on another sheet?
I have a sheet with a list of no longer needed items that may be useful to another group. I have setup a custom URL (custom per row/item using a unique asset number) that opens a form on a second sheet to gather the requestor's contact information. When that new row is created on the second sheet, can a workflow…
-
Workaround for all attachments sending in Update Requests...
Does anyone have a workaround for not wanting to show all the attachments for a row when an Update Request is sent with the option to attach a file? I am using Smartsheet to track RFPs and the information for each one is collected into one row on a Master Sheet using a form. This information will sometimes involve multiple…
-
if checkbox is checked, capture a value from same row and populate separate sheet
I would like to capture values from specific rows on a source sheet (Estimate Summary) when a check box is checked and send those values to a destination sheet (Allowance Log). When the checkbox is not checked on the Estimate Summary sheet, the value captured on the Allowance Log sheet should be zero. I've tried several…
-
Dropdown column
Is it possible to create a dropdown, single or multiple select, from a list in another sheet? The dropdown list will be used in a form.
-
What is best method to map data and manage ongoing changes from one Smartsheet to another?
I have been using a workflow automation to move a certain rows of information from one Smartsheet to another. These workflows are super easy and useful, but not that flexible. The provided workflow automation requires the column headers match up exactly between the two sheets in order to populate accurately. Where this is…
-
Find the Count of All Multi-Choice Answers
Hello all, I'm still a bit new to SmartSheet, so forgive me if I'm a bit ignorant here. I have a column that has several multi-choice options (Option A, B, C). I would like to know how many times, across all rows, each option was selected. The setup would look like this Row 1: Options A and B selected Row 2: Options A and…
-
Creating a chart from non numeric values
I have created a form for users to fill out based on their experiences with a certain process. They will be asked questions such as "were instructions clear" and they can answer Very Clear, Somewhat Clear, Unclear. I was trying to create a pie chart from this sheet that shows how many users selected Very Clear vs. Somewhat…
-
Active turn around times by status of a row
I was wondering if theres a way/formula to track the amount of time a line stays in a certain status. For example - If we are using a line to track the life cycle of a contract we would have a created date field and a contract status field. The status field would consist of fields like "Contract Review" "Legal Review" "On…
