-
creating row report & summary report from 1 sheet
I love the new summary report option but I still want to be able to create a row report from the same sheet. I have already created a summary report but I also need to add a row report to my dashboard for the same sheet. I used the summary report to create a chart on my dashboard. I tried to create a row report but the…
-
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
-
PROJECT DURATION - OVERIDE DEFAULT
I use a smartsheet to manage engineering tasks I have columns that calculate task duration based on work types I now want to convert this to a project sheet and have the task duration driven by an existing column Example: I would like my "Planned Hrs" column to determine the task duration Does anyone know how to have the…
-
Return top 5 occurrances
I have a sheet to track customer requests (500+ rows), with a Salesperson column and customer column, the salesperson column is located farthest to the right of the sheet whereas the customer column is located on the 1st column. What I want to do is write a function that will reference a given Salesperson contact and be…
-
Webform Help
Hi Team! I use web forms to a large degree now for installation sign-offs for our field engineers, they are working great. Is it possible to build a conditional branch into a webform? So if I ask a question "Are you proud of the installation?" This is answered via a YES or NO dropdown option If "NO" is selected Can the…
-
Report based on specific text in a cell
Hello, I have a data sheet used for a call log for project issues. I'd like to be able to run a report that displays all calls for a specific serial number based on which serial number is entered into a cell, a variable search value. Ideally, I would have a dashboard with a web content widget that would be looking at a…
-
Using IF to look at a Checkbox field and return "XYZ"
I am creating a Status field using IF function. I'm trying to look at a check-box field and return "status" (ex. "Tooling Complete") if the box is checked. I've tried IF(NOT(ISBLANK(... but a check-box formatted field seems to register as not-blank whether it is checked or unchecked. Does anyone know a different function I…
-
Combine single sheet in master sheet
Hai all. I need to combine 6 individual sheet into one master sheet. Then need to see all the detail. each sheet have about 120 line item. can any one help.
-
IF or IF AND Formula conditions DATE
Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 (Green) 2) If the Balance column is less than 0 (Yellow) 3) If the Balance column is…
-
Populating a Second Sheet
I have a form created for a sheet so that when it is submitted it adds a row to Sheet 1. How do I have a second sheet recognize that a new row has been added to Sheet 1 so that it can pull data from a few of the columns? Thank you, Matt