-
counter
hi I have a result column where the answer can be Yes, No or NA. I have a score column where I want to count to show a 1 if the answer in my results column is either Yes or No. I can do the formula if it is just Yes but am struggling with the either or. =COUNTIF([Opened by offering to help and providing name]@row, "Yes")…
-
Checking to see if Children are blank
I'm trying to create a formula to check and see if children tasks are blank. If they are blank the formula cell should be blank if not blank will complete another if statement. Here is the if statement I want to happen if the children are not blank: =IF(ABS(SUM(CHILDREN([JUL 21]3:[JUL 21]42))) = 0, [JUN 21]44, [JUN 21]44 -…
-
Auto populating a cell value based on potentially two different columns
@Paul Newcome @James Keuning Hello experts! New question, hopefully another phenomenal solution! We are developing a Continuing Education program at work. Different activities are worth different points. I have created a master data sheet with a form so that individuals can submit their own activities. What I need to do is…
-
Need to add a formula to a column when a new row is created
TL;DR - I need to autopopulate a formula into a cell when a new row is created without locking the formula to the column, and automations are crapping out on me. As the title states, I need to create an automation where a formula is added to a cell when a row is added. I cannot simply lock the column to the formula because…
-
Need to convert text to date
Hi Everyone, I have the value which is calculated from "Date with Time" column, which is text type. I need to convert the text value into date. Kindly help us on this. Thanks, Sandhiya P
-
SUMIFS; Need to know how much time is allocated to each cost center by employee
I am trying to figure out how much time is allocated to each cost center for each employee for the 3rd Qtr. Placing a formula into a metric sheet trying to reference the original sheet didn't go well, so I moved to using the below formula in the "sheet summary' in an attempt to roll up how much time per one cost center…
-
Forecasting Scopes of Work
Hello all! I am looking to do some forecasting! I have Data from a third party application that I bring into smartsheet as its own data. It has a Start Date Column, and End Date Column, a Duration Column, and a scope of work column. The Scope of work is consistent from Row to row, depending on what the scope entails. I am…
-
counting a name that appears in a multi select dropdown
i am trying to count the amount of times a name appears in a sheet (Column) the formula below works fine if a cell only has one name however if a cell has multiple names it will not count it from that cell, the formula i am using is =COUNTIFS({SNOW - ARIaDd Log assigned to}, $[Primary Column]@row, {SNOW - ARIaDd Log type},…
-
Does anyone know how to convert this SUMIF Formula and REF a date from another sheet
Hi, Were looking to take this active formula which is currently working and replace the date ranges from another sheet (Cross Sheet Reference) . Does anyone know if this is possible ? Because it is time consuming to replace the date range on each formula, we want to be able to edit the date range from another sheet.…
-
Ancestor and Checkbox Formula
Hello! I'm trying to write a formula that I just can't seem to get right. I've got a project with several ancestor levels that I'd like to report on. I'm close, but I just can't seem to get it. I've added a Parent Row helper column with a check box. I'd like the check box to equal True (checked) if the Primary Column is…
