-
Cross reference error
Hi there I have created a cross reference with another sheet and named the ranges as well. It works fine for few days and then after few days it shows invalid ref error Again i have to re refere the ranges in the formula and it works fine for few days. Please help me and guide, what i have been doing wrong. Kind Regards…
-
Formatting numbers like in Excel
How to format numbers in cells to show thousands separator and two decimal places. I tried to search , could not find any thread about this. Someone please help. I am new to smartsheet.
-
Yielding blank cells
Hello, I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not yet started, because the start date has not yet started or is not yet set, to remain…
-
Can I hide rows using a condition?
Hello, Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format? If that is not possible, is there a formula that I can implement that would get the job done? I am managing a photography team and they have expressed the concern of seeing too much on their sheets that would…
-
Formula Help!
I'm creating a dashboard that contains some metrics. I have my metric worksheet already setup and have pulled over info. I'm needing a particular formula and cannot seem to figure it out. Here is what I'm working with: I need to search one column of information for any input values for only the past two weeks IF a…
-
COUNTIFS and Date Range
Hi I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count. For this count I want to filter on current date date from a range in a column (Current Due Date). e.g. date range 30/04/2019 to 30/04/2020 =COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2,…
-
COMPARE COLUMNS
Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column. What kind of formula de you recomend to do this? I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1; false) and Match; =MATCH([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1) But i only…
-
Formulas for Column Dates to Autofill
Hello there, I have a sheet setup with 4 columns of dated. Project Owner Completion Deadline, Project Owner Actual Completion Deadline, Project Auditor Completion Deadline, and Project Auditor Actual Completion Deadline. I am trying to figure out how to set it up so that the Project Auditor Completion Deadline will auto…
-
Don't include parent rows in checkbox complete roll-up percentage
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that should not be included in this total. I had a formula that sort of…
-
Nested SUMIF formulas across multiple sheets
I am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have multiple hourly rates. We will call this doc "Hourly Jobs Breakdown". (Rates will all be in $00.00 format, I just forgot to…