-
Stuck on a formula involving dates
Hello formula gods, I need your help once again. :-) I'm trying to write a formula that looks at 3 different date columns. 1. Look at the 1. actual completion date, if not blank then make it green, if it is blank then look at the revised due date column, if not blank then red for past due or yellow for reminder, if…
-
RYG Symbols from 3 Columns
I am trying to return a RYG symbol based on 3 different columns(Decision) Approved, Needs Additional Information (Denied), or Submitted. Based on these 3 columns data, if any of them say "Need Additional Information", I'd like the Symbol (Status) Column to be the Red Symbol, however if all 3 Decision Columns are "Approved"…
-
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.