-
Way to find and change font on a specific set of rows?
I am looking for creative ideas here. At the beginning of our fiscal year, we copy just a specific set of rows from our enterprise project list to the IS project list. We change the font color on just this set in the receiving sheet so we have a visual cue when we look at the full list. Now, after the fact, we want to find…
-
Formula for counting dates in a month
I need to count how many jobs there were per month on another sheet, any tips on how to make the "COUNTIF" or "DATE" My current formula for the month of January that comes up as "Unparseable" =COUNTIFS({Date}, AND((>=DATE(2024,1,1), <=DATE(2024,1,31)))) {Date} is the column from the other sheet Help would be appreciated
-
How to count current week for the month?
I need a formula to calculate the week number for the month, for example 28 May 2020 is the 5th week of the month. I understand that week number calculate from w1 - w52. How can I calculate the week number for the month? So basically, the answer will be between number 1 - 5. Thanks.
-
Pulling Data from another sheet
I have two sheets with a few hundred rows filled with site information. The common data between each table is the site number. What formula would I use in a cell if I wanted my primary smartsheet to check the other sheet for the site number on a row and return data from a different cell in that same row? All site…
-
Using variables in Hierarchy logic
Is there any way to get the parent row number of a task from another Hierarchy. Im using a function that can call get information of its predecessor task, its working but i want to get information from that same predecessor's parent row. IF(TRUE STATMENT , (INDEX([% Complete]:[% Complete], VALUE(Predecessors@row + "") -…
-
Multiple IF / AND / OR Statements Help, Please.
This is such a great community and a wealth of knowledge for a new Smartsheet user like me. I have done several formulas, but this one has me scratching my head. I have a [Target Date] column, [% Complete] column, and status column that I would like to automate with Red, Yellow, Green, and Gray status balls. The [%…
-
COUNT function linked to another sheet
I have a sheet that captures outstanding items for a set of 5 projects that we use to drive weekly status update meetings. I want to create a chart in our dashboard that shows the number of tasks for each project, and possibly one that shows how many have a status of "at risk" or "overdue" which are columns on my sheet.…
-
Read Only Mode
I'm facing a strange issue, i've created a mastersheet with around 5000rwos and 3500rows have data on it and those rows linked to another four sheets for particular data, now if i open my mastersheet it shows "we weren't able to load your sheet's cell links and had to make your sheet read only for now. sorry about the…
-
Need help merging repeated sub tasks with schedule steps
I am trying to figure out a way to merge high-level schedule steps with more granular tracker steps without having to build a whole new, super repetitive template. I have a master schedule that lists out all of the tasks for a project at the chapter level. However, each chapter breaks down into multiple parts, and those…
-
Error Check - Combining multiple IF/AND statements for calculation based status.
Hello, hope you are having a great day, I have issues using IF/AND combinations in formulae. I am trying to get a status off the percentage calculated in a different field (percentage value) and keep getting this error that says - #INCORRECT ARGUMENT SET This is my Formula- Details8 is the field where the percentage is…
