-
Parent/Child Status
Hello, I'm trying to get a setup going in my project templates where the parent cell will update based off the input of of the children cells. For example, the main parent is "Onboarding", with children "Licensing", "Credentialing", "DEA". Then, each of those children has their own children to track individual providers.…
-
Detect Change and Automate Update in Cell
Hi! I’m new to the SmartSheet community. If any of the values in columns named Date, Shift (drop down), Staff Name (drop down) or Role (drop down) change and the value in column called SSU Supply (drop down) says Added, I want the item in a column SSU Supply to change to Update. I hope this makes sense and any help would…
-
How to provide a checklist as a column in a form
Scenario: I want to make a form which is basically a guided walkthrough for customers to find out what they need to submit in order to be onboarded (Follow a series of conditionally-linked questions and at the end it will tell you what documents you need to submit in order to have the optimal onboarding experience) I'm a…
-
How to fill of data automatically via Master sheet to Child Sheets?
Hi, I have a scenario where I have a Master Sheet that is attached to a request form. I have more than 1 child sheet attached to this sheet. Not I want rows of these child sheet to be filed up depending on the text entry of a column in the master sheet. I tried VLookup, Index Match but not working it just fetches out the…
-
DASHBOARD and COUNTIFS
Hi guys, Can someone help please - I am trying to build a dashboard, but need some help with formulas. I have a sheet that has a month column, and a reason column. I need a pie chart to show in a certain month, how many of a certain 'reason' have been counted. Please see below image for better explanation! I have tried…
-
Need help to modify the given formula.
Hi, I and trying to write following formula where first it is checking the row ID and then matching content in the other column in the same row and returning the incremental value, but it is throwing #INCORRECT ARGUMENT SET error. =IF({WorkOrder#} >= 1, INDEX("TD"), MATCH(({WorkOrder#} >= 1), {WorkOrder#}), 0) Prajna
-
Sumifs - Cross Sheet Reference Range Movement
I am working on a calculation where one sheet has month on month cost for a year in columns. i.e. Jan Cost, Feb Cost, Mar Cost etc. in sequential order. In another sheet, I am doing some calculations to prepare the category wise costs based on the first sheet. For each month, all the conditions are same except for the sum…
-
Supplier assesment
Hello, I developed a questionnaire for supplier evaluation, the score obtained from this form will feed at one point my supplier score card. What I want is for the form to be automatically scored regarding the response received by the supplier: for example if Question 1 is "one of the proposition" ( from a column with 3…
-
Calculate % on time deliveries for team
Hi, I was able to use the following formula to count the % of on-time deliveries per team member. =COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC") / COUNTIF(Reviewer:Reviewer, "ABC") We have several team members, so what formula could I use to…
-
Referencing an entire column from another sheet
Hello, I am working on a cross-sheet formula. The ultimate goal is to write something that says this: If room column on [Sheet 2] contains "room name" AND (date on [Sheet 1] falls between Check in Date and Check Out Date on [Sheet 2]) return the value "reserved," if not leave blank. The trouble I am having is referencing…
