-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
How to make COUNTIFS formula to count separately?
Hi guys, I have a question regarding the COUNTIFS formula. The following is my problem. I would like to count the projects, which have the project status "In Progress". For each of my 10 projects, I have a separat folder with the same sheets in it. In every sheet "10_Project Metadata" I have linked the project status (Not…
-
INVALID REF Issue
I am using the following formula and having intermittent #INVALID REF issues. Every few minutes (most likely when the formula is refreshing) it will show #INVALID REF. If I open the sheet and then refresh the formula fixes itself for a few minutes before erroring out again. Any suggestions? The first COUNTIFS formula is…
-
INDEX/COLLECT FORMULA PUSHING OUT "#INVALID VALUE" - CAUSING CHECKBOX FORMULA TO FILL IN WITH SAME
I'm trying to gauge training impacts for different business areas within my organization for specific projects. I have a sheet in the background that's pulling if the business area has marked if they have a "training impact" or not in relation to a specific project. Example: Business Area 1 responded "Yes" to having…
-
Copying Date columns and making them editable from reports
Hi, Back again with what I hope is a simple fix. Background - I am creating a global project tracker, used to manage and maintain over 2k current projects and ~100 new/ intake projects on a monthly basis. Requirement - The intake form feeding the SmartSheet is asking for a Start Date (intake), Launch Date (intake) and…
-
Formula Challenge
Hi Smarties, I am trying to get this formula right in the Formula Challenge from Smartsheet. I am not sure what I did wrong so hoping fellow Smarties could help! In the Parent Row symbols column, write a formula that returns the most common value of its children. If there are equal or more reds than yellows or greens, the…
-
IF Condition issue
Hi, Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column =IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty")))) THanks
-
Metrics in capturing SUM per Monthly
Hi Everyone, We are aiming to create a new metric and visualization that will allow us to automatically calculate the total numbers of FTE per month. Based on the sample data set below, the calculation will go like this: February 2021 -> 110 + 200 + 200 = 510 March 2021 -> 20 = 20 April 2021 -> 120 + 4 + 4 = 128 May…
-
Automatically Select Contact With Column Formula
Hi, I am fairly new to smartsheet so I apologize if this is a basic question. I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from many sheets, a filter that only allows a row assigned to a contact to be shown can be…
-
Conditional Logic - Setting a Value
Hi - I know a few months back Conditional Logic was added to the Forms which is awesome. I was wondering if there's anyway (that I'm not seeing) where I can use a Dropdown, Radio Button, etc. - to set the value of a Status field. In other words, If Someone Selects Option A from the drop-down, then Status 1 is set, Else,…