-
Health Ball Color Base on Start Date, End Date, and % Complete
Hello, I am relatively new to Smartsheets. I am trying to write the following formula but continue to hit an "UNPARSEABLE" Error. I am sure I am missing something but cannot find the issue. I would appreciate assistance. This is the core rule I am trying to draft. Here is my formula attempt: IF([% Complete]@row = 1,…
-
Formula Automations
Hey everyone! I am trying to adjust or update the formula below to include "if the status column is changed to "terminated" the parent row will read that as "complete" and when all the other child rows are marked "complete" the parent row will change to complete. However, I also need the parent row to read "in progress' if…
-
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…
