I noticed that the formula I was using wasn't working so I moved it to a text column to see if the output is correct. Turns out the output is giving me 0, so no wonder the checkbox isn't checking! My …
I have a sheet where there is a helper column that says either Parent or Child. If the helper states "Parent", I want the checkbox in a column named "Report" to be checked. Otherwise (if the Helper st…
I'm trying to automatically identify whether PIs in my departments are collaborating on various projects. I'm essentially looking for a formula that will identify in a column when up to 4 departments …
Hello, I have a column that's a date and need a formula on a separate sheet to count if the date is current year. I haven't been able to find any community posts about sheet references, only cross she…
Hi all, So I was able to get help around here on how I could turn amounts in thousands and millions to just K and M instead of displaying lots of zeros. Now I would like to add a formula in to just ro…
I have 2 sheets, a source sheet and an update sheet and need help updating a cell when 3 criteria are met from the source. Employee ID = Employee ID (Range 2) Date = "11/6/2023" in source sheet (same …
Hello All, I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Form…
Hello Smartsheet Community! I'm trying to create a formula that generates an integer value based on two criteria. I have one sheet that acts as a repository for all of the daily activity at multiple s…
Hi there. In part of my duties, I run a report that shows activities entered on a form from yesterday. We do achieve "yesterday" by using the following formula: =IF(DATEONLY(Created@row) = DATEONLY(TO…
Hello everyone, i have a layout where project managers fill in all relevant information into an intake sheet. And then i have created some formulas and automation so that the project sheets would fill…
