-
If column is true return value from another column
Should be simple but I'm struggling. Have a column for % complete and another column with a formula value. If the % complete is at 100% want the formula value placed into a third column.
-
COUNTIFS Error
Here is my formula: =COUNTIFS({All Qs}, "Yes", {Hospital Match}, [HFMC Score]$15, {Month}, [Primary Column]@row) I am getting an #unparseable error. Each component works using COUNTIF. Do you see something I don't see. Thank you, Linda
-
Due Date w/Multiple Conditions
Hi Community! I'm looking for some help. I've been tasked with creating a "notice tracker". The team would like the [Due Date]@row to be some what of a dynamic date. Here is a snip of the sheet and the columns I'll be using. The sheet is fed via a form. The form has "Response Due Date" but is not required. It will only be…
-
AVERAGEIF when referencing another sheet
I've used this formula multiple times and I am not sure what I am doing wrong on this sheet but I cannot get it to calculate. I have tried, =AVERAGEIF({CSB QA Report Range 1}, Name@row, {CSB QA Report Range 2}), I have tried =AVERAGEIF({CSB QA Report Range 1}, CONTAINS(Name@row, @cell), {CSB QA Report Range 2}), and also…
-
Restrict set of checkbox columns to only check one per row
Hello, I have a set of 5 columns adjacent to each other, all of them formatted as checkboxes. Can anyone suggest a way to restrict a user to only checking one box per row, out of the 5 available? Thanks, Dennis
-
Nested if & countifs to generate a prefix based on number of occurrences
I am trying to get this part of a concatenate to work but keep getting #unparseable. The latter part of the concatenate works and generates a unique identifier for the project. However, the beginning section is meant to generate a prefix based on whether this project is the first, second (b), third (c) etc. project with…
-
need pls. advise for formula
Hi, pls. see pic. below: I'm looking formula that will light in green column called greenlight to install , when all other columns are checked and red when at least 1 column is unchecked Thanks in advance Yuval
-
Can I create a report from google sheet file?
I'm looking to transfer some information from google sheets into smartsheets report so later on I can do a dashboard inluding different information. The file in question is a tab with Pivot table from different tab See example below is this even possible? Regards Marcin
-
What is the correct approach?
I am trying to pull certain data from one sheet into another. If the data in a column meets a certain criteria (i.e. apples or oranges and not pears and bananas) then I want that data pulled from the main sheet into another sheet with the data and the product number. This data can change from day to day and what to keep…
-
Please help me convert an Excel formula into a Smartsheet formula
The following formula works in Excel and I'd like to recreate it in Smartsheet: =if(C2+1, D6) In Smartsheet, my column C is called Session, and column D is called Training Date. The Session column includes numbers only. Please let me know if you need additional info, thank you!
