-
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…
-
Tracking Request Hours and Placing Requests into a bucket based on # of hours used
First, I appreciate all the help and suggestions, since I'm struggling with how to accomplish this task. I have a sheet that contains requests,(assigned a unique number) as requests are approved the # of hours is captured for each request. Each billable bucket is capped at 1800 hours and requests can spill over from one…
-
Days to Complete Formula for Each Request Type
For a sheet that contains a list of service requests received, I would like to return the number of days between the "Requested Due Date' and the "Actual Completion Date" for each "Request Type." I tried using NETWORKDAY(s) to just return the number of days between the two dates but I keep getting UNPARSEABLE errors. I…
-
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…
-
How do I write a nested IF formula to count a location if 1 of 2 trigger answers appears in a field?
This is the formula I tried, but I'm missing something. =IF(OR[Location Status]@row = "Active", "Operational", 1, 0) Thank you for your help!
-
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…
-
Mimic a Pivot Table, Group by date and SUM
I'm trying to figure out how to essentially mimic a pivot table using functions. And no we won't be getting the pivot table app hence needing this solution. I want to group items from a sheet by matching dates in a column, and SUM the contents of a few other columns based on those matching dates. The SUMIFS is part of it I…
-
Health Formula - RGY
Looking for an assist with a formula. I want the parent health bubble to show the 'worst' status of any of its children. Basically: if a child's health is red, the parent's is red; if a child's health is yellow, the parent's is yellow, otherwise the parent's is green. Thanks!
-
Help with IF AND OR and CONTAINS in formula
I am trying to check a checkbox column if another check box column in the row is checked AND another column in the row contains either of two values. I can't figure out if I should use CONTAINS or OR and how to nest the IF. something like this..... IF (AND (checkbox1@row,1), IF(text@row contains "A" or "B"),1)
-
Sumif Month Formula
Hi I'm trying to find a formula that will sum up Hrs if a month is e.g. 6 - see screen shot below for the forumla I'm using but it's coming back with a blank, despite hours being calculated What am I doing wrong? TIA Cheryl