-
Countifs in date range and value range.
I am stuck on this formula, it doesn't become unparseable but it doesn't result in an accurate count. My goal with this is to is to keep an annual tally of a specific age range of patient the formula is as follows: =COUNTIFS({Trauma Chart Audit Age}, <15) + COUNTIFS({Trauma Chart Audit Age}, NOT(ISNUMBER(@cell)), {Trauma…
-
Help with sorting numbers and letters that are combined in one cell?
I would like to sort by a column that has both numbers and letters in a cell. Such as 1, 1a, 1b, 1c. Right now if I sort it by it by the ascending option, it's able to do 1a, 1b, and 1c correctly, however it separates it from the numbers that don't have any letters. For example: This is what it does: 1 2 3 1a 1b 2a 2c 3b…
-
Date settings don't stay saved in project settings!
Hi, I have changed the date settings of my many projects, so that as I zoom in and out I can always see the fiscal year that I am in. Our projects are very date focused and eventhough I change the dates and save every time when I go back later it hs changed back so that the year is no longer there. What good does it do to…
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
What formula would I use to read a date from another sheet?
I have a sheet that collects dates in a column "CO Internal Target", I want to be able to list that date on another sheet with a formula. It should be able to read the "Studio Code". Both of the columns are on both sheets. The sheet that I am wanting to read from is the "Location Tracker - SS", the sheet that it is going…
-
Organizing attachments
Hi, Is there a way to organize attachments, so I don't have to scroll through all my attachments? I saw a question like this from 2021 and was wondering if there was a solution. Thanks
-
Auto Delete rows
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
-
RYG Arrow Colors
I would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down. This is helpful for budgeting in project management where at a quick glance you can see if we saved money on an item or lost money.
-
Can I create one:many and many:many relationships between two SmartSheets?
Hello, I have two related SmartSheets covering different aspects of my data. I would like them to refer to each other so that I can ultimately pull certain aspects into a report. I prefer to use SmartSheet over SQL in order to take advantage of the workflow and approval capabilities. However. I cannot figure out how to…
-
Count distinct values within cell
a
