-
True/False IF formula not working?
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 issue is that I'm trying to get a checkbox to check if the values are either -5 or 5. However, I'm stumped on what I'm…
-
Check box for parent row only
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 states "Child") I want the checkbox in the "Report" column to be unchecked. Can this be done with a formula or conditional…
-
How to create if/then formula to identify differences in text columns
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 are not equal. Suggestions?
-
Sheet reference Countifs formula with a date
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 sheet ones. Current formula: =COUNTIF({Date Column}, ISDATE(>2023)). I get an invalid ref error.
-
Help on formula: format numbers and shorten to K (thousand), M (million), B (billion)
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 round it up with just 2 decimal places and to shorten billions too. Can someone help please? Here's my current formula:…
-
I need help with a formula with 3 range references from another sheet
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 row) (Range 3) A calculated field on source sheet = 1 (Range 4) The third criteria is new so this formula works today:…
-
Why would a formula work on one sheet but be #unparseable on another?
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 Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable. This is…
-
Formula to Match cross sheet and COUNT instances.
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 sites, for each day of the year. My formula needs to MATCH [Date@row} to the cross sheet reference range {Master Shipment Log…
-
Issues with TODAY() and daily reporting
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(TODAY()) - 1, "Yesterday", "Not Yesterday") In using this formula we have noticed some alarming discrepancies. Reports with…
-
Copy a date in a cell that is formated as a date
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 themselves upon creation. So far so good. Now I have different date columns in the project sheet that need to be filed in…