-
Hi,
I am using the following formula to count those occasions when CSOD (unit) is impacted by CFCD (unit) and the status of the impacts is either 'conceptual' or 'complete' and it does not work. If I limit it to only counting 'conceptual'…
Formulas and Functions5
Phil Wightman
-
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 fi…
Formulas and Functions9
Erin Becker
-
I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of…
Using Smartsheet7
Kevin McIntosh
-
Can anyone tell me what might be wrong with this formula?
I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2…
Formulas and Functions1784
laura.buchanan
-
Good Afternoon!
I am trying to sum children rows where certain status' exist where the Pick-Up Date is today, within the next two days, and in the future beyond that. (Really, 3 formulas).
(Image) I tried applying the following formula bef…
Formulas and Functions12
Davis Dye
-
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};…
Formulas and Functions9
Sebastian Avila
-
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…
Formulas and Functions9
Nikki McIntosh
-
Please help, what's wrong?
It couldn't be parsed...
=IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ")
Thank you in …
Formulas and Functions13
Anna Pelipas
-
Hi,
I'm trying to set up a formula to count the number of requests that were submitted between a specific date range. Below is the formula that I've written, however I'm still receiving an invalid operation error. Can anyone help me with t…
Formulas and Functions9
Cassie Sprague
-
I am trying to reference an automated creation column from sheet A to populate date AND time in a column in sheet B. I have been successful in the reference, but then have to format the receiving column to date format due to invalid data…
Formulas and Functions9
Emerus CCC
-
I would like a formula to check a box for open cases. I have a start date column and an end date column. Only check the box when there is a start date and no end date entered. Thank you!
Formulas and Functions14
Emerus CCC
-
I know my question itself is confusing, so let me explain. I have configured data to come into Smartsheet from SharePoint via Power Automate. It is depositing some basic metadata into a "From SharePoint" sheet (image included her…
Formulas and Functions18
[email protected]
-
I am attempting to do the following.
If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100%
Here is the formula I thought would work using task 4.of the project.
=IF(Complete…
Formulas and Functions190
chicago25624
-
Hi everyone -
So i am trying to find a way to sum values in cells containing both number and text like "1 Macbook Pro, 2 Lenovo Tiny PC, etc. and give me the total for each item type in the totals column.
Please see the screenshot of…
Formulas and Functions15
Nav
-
Hello and please 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 sh…
Formulas and Functions13
Nikki McIntosh
-
Hello,
I'm not sure which combination of formulas I require (VLOOKUP, IF, INDEX, MATCH...)
In sheet 1 I have the columns "resource name" (text) and "onboarding paid?" (check box)
In sheet 2 I have the columns "res…
Formulas and Functions12
Hannah H
-
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…
Formulas and Functions16
Mandy Maleta
-
Our company works in two week chunks we call iterations. Using the following formula in Excel I am able to calculate what the current iteration is. However when I import from Excel Smartsheet doesn't appear to like the formula.
Using the c…
Formulas and Functions12
Anthony Carabbio
-
I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-mont…
Formulas and Functions11
Corey Fletcher
-
I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date every time the sheet is opened and saved…
Formulas and Functions9
Priscilla Awad
-
I'm trying to basically show sr. mgnt how many high project projects are all happening at the same time -- ideally I'd like to count them -- is there an easy way to do that?
Essentially I'm using project type = High then want to show thos…
Formulas and Functions13
Sborror
-
I'm trying to create a formula for a report that references another sheet but it needs to reference and check two columns. My crude formula below to illustrate:
=COUNTIF ((RefSheet1Range1)="Windows Server" AND (RefSheet1Range2){…
Formulas and Functions8
Geoffrey Kemp
-
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/0…
Formulas and Functions24
Lindsay Wilson
-
How do I make this formula ignore blank cells? I want it to total the percent of YES cells to NO in a range.
=COUNTIFS(CHILDREN(), OR(@cell = "YES", @cell = "No aplica")) / COUNTIFS(CHILDREN(), OR(@cell = "",…
Formulas and Functions27
Alishia Topper
-
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/n…
Using Smartsheet56
Daniel William Maycock
-
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.
Formulas and Functions82
FazalurRehman
-
I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank.
Project Status = Active
Schedule Complete Date…
Formulas and Functions29
Corey Fletcher
-
Hello,
I have a formula that returns a Red, Yellow, or Green icon depending on criteria in another column. Red, Yellow or Green correspond to a priority in our work order flow.
Then, in a metrics summary sheet, I have a Sumif formula ba…
Formulas and Functions16
mlanterman
-
Hello team
can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value
thanks in advance
oded
Formulas and Functions902
odedL
-
The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird.
Is this only on my copy o…
Formulas and Functions70
Jamie Bedford
