Hi, I have a Planned Date and Actual Date and Final Date column. I need formula where Final Date column, has Actual Date, but when Actual Date is blank Final Date should have Planned Date. Planned Dat…
Hi Everyone, I need some support with a formula, if anyone can help me 😁 I have the below sheet where I have created costing for resource use between a Start and End Date Column supported by a total …
I am try to find the right formula to count how many interviews are within the last 7 days but also count anything happening in the next 7 days. The formula I used for the last 7 days is: =COUNTIFS([I…
Hello, I have a project plan in Smartsheet with 2 columns: % Complete Relative weight of completion This cells are used in parent rows (the phases of the project) and are used to indicate the completi…
Hi, I have a formula with multiple conditions, so I used index/collect to pull the data. However, that didn't pull the data. Basically, if the ID# in sheet A matches sheet B and the details column in …
When the following formula is applied =IF(COUNTIF(CHILDREN(), OR(@cell = "Yes", @cell = "N/A")) = COUNT(CHILDREN()), "Yes", "No") it results false positive values since blank children cells are counte…
I manage training records and am creating a dashboard to manage who needs to complete a training. I have a master sheet with the employee name, and a reference column to them completing the training a…
This formula is working at the cell level but I would like to convert it to a Column formula so it automatically applies to new entries added to the sheet from a form. =Weight2 - $Weight$1
I'm relatively new to Smartsheet and use it as a tertiary tool, so apologies if this is a 'basic' question. What I want is to tweak a formula on one row of a column and have it apply all other rows th…
Hello, Smartsheet community! I am stumped on a function. I have attached a photo of a dummy sheet with the same functionality I am trying to achieve. Using the example, how would I set up a formula wh…