Hi, I am currently working on a project where I will have multiple check boxes on a row where each checkbox is going to of different values (true/false). I need a formula that will look over the check…
I am new to smartsheets and I am having a hard time with a formula, hopefully someone can help me. I am trying to create a formula that will indicate the status of a task based on the following condit…
Hi All, I'm trying to implement an IF(AND) function within my sheet that is dependent on a number of other conditions on sisters sheets being true to display a string and if false, a separate string. …
Hello, I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved. The column "Status" can al…
I have a spread sheet with a column (with a formula) that counts how many days it took for each project to get from one department to the next. I am trying to figure out a formula to add all those day…
Hi, Can anyone share how they're tracking their teams resources? The resource allocation is great however, it only allows me to show one team member not multiple per task. In addition, I'd need this i…
Hi, i am hoping this is possible and someone can help? We have created a sheet which is populated from a form and is working really well. We populate the "Required completion date" base on the type of…
Hi i am looking for some help with some dashboard data. I would like to display data from a sheet that shows all data captured (YTD) and also current month data. This will be displayed in two metric w…
Sorry to bother with such a simple question, but what is the problem with this? =IF(OR([Average 6mths]7 * 1.5 > [Current Monthly Usage]7, [ Average 6mths]7 * 0.5 < [Current Monthly Usage]7), 1, 0) I a…
I'm looking for a way to auto number my WBS. I believe I have found a way using logic functions combined with the Match function. The issue I am running into is that I am unable to reference a cell, s…
