I reached out for assistance recently about formulas to count specific projects for individual weeks. The formula assistance I received counts projects from today + next 7 then 13 days then 21 days. W…
Hi community, I'm new on Smartsheet and I'm trying to make a formula to automatically calculate the status of a set of tasks (or subtasks). Let me explain my situation: I've created a main task, lets …
I would like to the sum of one column based on a specific date range in another column. e.g Need to total costs for June 2018. I am using the following formula =SUMIFS(Cost3:Cost29,[End Date]3:[End Da…
i am trying to count the number of matching pairs of values in two columns. eg: Column A Column B 1910 760 1910 810 1910 810 1990 760 1990 760 the outcome of the above that i am looking for is as foll…
Hello, I have a formula that I'm attempting to count the number of projects within the Task Name column that have "hot CX" as part of the name. Task name is customer- Hot CX My formula returns a 0 cou…
Hey All, I'm having difficulty getting my card view tabs to show a certain color based on percentage complete for the subtask. When I create the rule it either highlights all the subtasks based on the…
I am attempting to use a collect with no criteria, that is it grabs everything and am having some problems. =JOIN(COLLECT(Return:Return, a:a, IF(ISBLANK(a10), true))) my desired behavior is that if ce…
Hi, I would like to only apply conditional formatting to cells that are percentages. My rules currently set any cells that are over 100% as red, and 100% or less as green. Due to the red rule formatti…
Hey everyone, I've got a set of data pulling in completion % by date, and want to give my team a quick snapshot of overall health of the project based on completion % for TODAY(). I have used the foll…
within the same report as my list of projects I'm trying to return a count of projects that are due to start within the current week (day 0 - 7) from "today" then return a count of project for next we…
