-
IF Formula - 2 Conditions and 1 Flag
I have a column that houses a flag to notify if the billed hours breach the budget. But I am trying to use two conditions where it doesn't run if Contract Type contains T&M. My first attempt right now: =IF([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, (IF([Contract Type]@row,…
-
workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
Count previous month items
Hi i am creating a metrics for a Dashboard and i just need a count of new items that were created in the previous month. I am using as base the "created date" column. For your reference i already have one that is counting the items created during the current month and it is working. What i don't know if where to include an…
-
How to count number of tasks and due dates of another sheet
Hi, I'm trying to make Metrics sheet which I would like to calculate the number of tasks of each person by name and also their past due tasks I did some formulas but they seem to be #INVALID Below are the formulas I did for tasks : =COUNTIFS({Name of other sheet Range 1}, FIND("Name", @cell) > 0) Formula I did for past due…
-
*urgent request* - Days until Formula
Hello SmartSheet World, I am wondering if there is a good formula that can provide me the number of days until a date is reached? In the snip below, there will be a date added to the "CO Date ..." column and next to that column I want to create a formula that tells me how many days there are until that date arrives. Is…
-
Networkdays and If formula help
Hello! I could really use some help. I've reviewed previous Q&As and can't get my formula to work. I want to calculate net workdays based on a specific status selection and have it stop counting days once the status has changed. Status is in dropdown selection box. I've automated the start date to populate when the…
-
IF function in column formula not working
Hi Community, I have an IF function that I have working on a row but if it try and copy the formula into row below or convert to a column formula it does not work and gives #unparable. Formula is below. Am I missing something obvious? =((IF([FAS Time]@row > 0, "FAS, ")) + (IF([FSE Time]@row > 0, "FSE, ")) + (IF([Cust Care…
-
How to count number of Past Due Tasks
I use the formula below to track my past due tasks : but it is not giving me the correct number currently my sheet does not have any late task according to my filter below : Which formula should I use to make it possible ?
-
How to Track Someone's Past due Task
Hi, I have tried to write down a formula at the sheet summary that tracks the number of past due tasks assigned to a specific person on my sheet but it is giving a #UNPARSEABLE error below is how I have done it : =COUNTIFS([Is Past Due?]:[Is Past Due?], "Yes", Status:Status, "In Progress", [Assigned To]:[Assigned To],…
-
How to count the number of Flagged rows
Hi, I'm trying to count the number of rows on my sheet summary that are flagged on my sheet it seems my formula is not working it gives #INVALID DATA TYPE error Below is the formula : =COUNTIF(TBD:TBD, @cell) The name of the column is TBD as seen on the screenshot below :