-
RYGGrey ball formulas for multiple columns (beginner)
I am trying to automate the RYGGrey ball status column, based on two date columns ([Start] and [Finish]) and 2 check columns ([Task Started] and [Task Completed]). Having trouble getting started and follow the right syntax. Here are my conditions I am trying to meet. TIA for your help. Grey * If TODAY < [Start] and [Task…
-
Combining COUNTIF and IF statements
I am ultimately trying to add KPI data to a dashboard, but am stuck on the formula. I want to look at two columns of data (Status and Priority) and cannot get the formula correct. I want to show how many rows we have for each Priority level (I am using Stars, which are represented in Smartsheet as "zero", "one", "two",…
-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Using formulas in date fields which reference another field
I'm trying to enter a formula in a date field which is 10 days earlier than the date in another field. I read that I can perform calculations on date fields (https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates) and reference another cell in the formula…
-
Count # of values in a Multi-Select Cell
I have a multi-select column in my sheet, and I'm trying to count how many items are actually selected in each cell. Is there a way to do that? I've seen a post that suggested creating a "helper column", but can't figure out the formula that would actually do the count.
-
Nested IF (AND (OR))) Formula for Flagging
Hi there, I want to be able to flag a column based on a "Status" and not by using a "% Complete" column. I want to flag a row/task that is <= 3 days from an "End Date" column value and IF that "Status" if "Not Started" OR "N/A" OR "In Progress. The formula I've come up with is : =IF(AND([End Date]@row < TODAY(3),…
-
Matching values from different datasets
Having difficulty trying to match 2 distinct values from one sheet to another. We have one dataset that tracks submissions on a daily basis from multiple locations. I been trying to find a way to match 2 distinct values from one sheet to cross reference the master sheet to verify if a form submission was conducted from the…
-
Sum up rows within the VLOOKUP formula
Hi everyone! I have several projects in my time tracking sheet and would like to use the VLOOKUP formula to save only the times per project in a monthly cost table. For that I used the following formula: =VLOOKUP([Project Number]12, {Sheet - Time Tracker (10-October) Range 1}, 8, false). Unfortunately, I only got one labor…
-
Extract a number from the Left of a cell - HELP!
Good Day to ALL. I am new to the vommunity and need some help.... I have a survey form for my clients and when the results are populate, I would like to tally the results - by client. What I am looking to do is extract the number to the left of the survey response. eg. 5 - Very Satisfied 4 - Somewhat satisfied 3 - Neutral…
-
Sum column if date is blank
I'm running into issues summing contracted fees for projects that are unscheduled. I have formulas set to sum fees per month already but unable to find a formula that works to sum fees based on no date entered. The formula outputs are in a summary being pulled from the active project sheet. The month formula for Dec 2019:…