-
Using COUNTIFS and OR statement
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
Index Match Multiple Criteria across sheets
I am trying to create a formula that matches criteria between two sheets, then populates a cell based on the criteria's results. The goal is to use an index/match to populate the "fee" cell in the second picture based upon the client and service level. Could someone explain how to create this formula? Thank you.
-
COUNTIFS + OR - Forumla Help
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
TotalFloat with multiple phases
Hello, are there recommended best practices for handling dependencies when calculating TotalFloat, =TOTALFLOAT([Primary Column]@row)? In this example, Milestone 0 requires that Tasks 1-3 be completed and is a predecessor for beginning the next project phase. TotalFloat calculates values for tasks 5 & 6, but it does not…
-
Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
-
Can Only reference a total of 100000 cells (combined) from other sheets. Please select fewer cells a
Hi All I am a newbie to Smartsheet, been working on it for a few months only. I am getting this error. Google is not helping me much. Please can a good samaritan assist me in this forum? Thank you so much. Existing formula that I am trying to update =COUNTIFS({Archive Sales Stage}, [Primary Column]@row, {Archive BU},…
-
Subtracting Days & Months from Specific Dates Using a Separate Day/Date Column.
Hello all, I am having some trouble trying to use the correct formulas to subtract both Days and Months from certain dates. I am also incorporating a helper column that would allow me to change the days or months if needed. Hope this makes sense. I have also attached a screen shot of the table I am working with at the…
-
How Do I Contact the Smartsheet Support Team?
Hi Team We are using Smartsheet in our Organisation and urgently need assistance with some formulas which are giving us issues. I am not sure who to contact please, can someone assist me? Thanks so much Benie
-
Index Match not working
Hello, Smart community! I have something that seems VERY simple that just doesn't want to work. I'm using Index/Match. The sheet I'm referencing has a Primary Column (QMS) with a numbering system to identify if it is a Risk (R) or Opportunity (O). I have put in 17 rows of "R"s (i.e. R01, R02, etc). The sheet I'm trying to…