-
Countif of children cells
Hello everyone! I got stuck on a formula that I need as KPI to monitor a project. I need a formula similar to the one that appears by default and that shows the percentage of completed task per macro level. In my case, I need it also for the other activity statuses, such as in progress and not started, so that in the endβ¦
-
Why is #INVALID OPERATION displayed in a cell momentarily?
The smartsheet has a column formula, ="https://trackpoint.[MyURL].com/projecttracking.aspx?ProjectID=" + [TrackPoint ID]@row, (I've replaced the valid URL with "[MyURL]" in the formula displayed). Upon opening the smartsheet, every cell in the column displays, #INVALID OPERATION. After a few seconds, the values in theβ¦
-
COUNTIFS with multiple criteria
Hi all, I am looking to count a data range based on the criteria in two columns (yes, I'm British, hence the spelling!) The fist column is a simple choice of three individual words, Ordered/Live/Complete. However, the second column has all our different contract types which I've narrowed down for the purposes of thisβ¦
-
Subtract minutes from Hours
Greetings, I'm trying to subtract minutes from a set number of hours and display the amount of time left in HH:SS. For Example: There are 10 hours available for testing but totally the environment came up 35 minutes late. I know it is something simple but I'm missing it.
-
Create an automation to move dynamically copy a row to a new sheet
Hi, So I am currently working on the system where I can dynamically copy aggregation of some data from master database to another sheet. We set up a master database on project level to collect data from form submission, this sheet contains all data from all projects for every quarter. The projects delivered by two deliveryβ¦
-
Quick Formula Help
Hi Community, I'm working with a colleague to create a column formula with multiple IF conditions. Just struggling to get our initial chain going before adding in others. What we need: -We have a column entitled "Submission Type" that contains a dropdown list of different submissions. Each submission has an estimatedβ¦
-
Status is <> Complete and the Need by date is behind todays date then should change symbol to RED
IF the status is not COMPLETE and the need by date is behind todays date would want to have the color be Red. If it is current or in the future of todays date would be Green. Been striking out... here was my latest try =IF(Status@row <> "Complete", "Red", "Green"), IF(AND([Need by Date]@row<=TODAY()), "Red", "Green")))
-
Raise Flag Formula
Hi, I am struggling to get a formula to show: When the dropdown 'Pending' is selected a red flag is raised? Thanks for your help in advance!π
-
trying to formulate a calculation
COUNTIF({Range}, AND(>-365, <0)) so i have a column for # days to due date and based on that, i want to count the number of tasks that are due for the past 12 months and above is the formula that i created but im getting invalid operations. please advice further. i did include the range.
-
Error when using =Month formula if no date in a column
I am using the following formula: =MONTH([Due Date]@row) If my "Due Date" cell is empty I get the following error #INVALID DATA TYP I may not always know the Due Date until the project moves on for some task. I am looking for away to modify the formula to ignore a blank Due Date and give me nothing or return a "0" Any helpβ¦