-
Formula help wanted
I'm trying to return a count of the number of cells that a) have a specific issue type and b) have an issue date within the last 7 days (I also want to duplicate the formula for 14, 30 and 90 days). I'm fairly new to smartsheets and formulas and I can't figure this out. I've managed the total count (i.e. the total count of…
-
Mixed Sheet Structure
I have a Sheet where users enter tickets for Enhancements to current applications. These could be any type of requests and there are several steps necessary prior to approval to start work. There are two types of enhancements that when approved are 'tracked' on a different log, though specific fields updating the primary…
-
Help with a formula between two sheets
I have one sheet that pulls information from a form. I have a cell on (Asset Tracker) that has a value of the requested items. On another sheet (Uniform Inventory) I want to count the total number of items requested on a continuing basis. I've written this formula, but I don't think it's correct. I get an uparsable error.…
-
Looking for More Efficient Formula for Calculating Weeks
Is there a more streamlined method to calculate the number of weeks between a specified start date and a set date without resorting to intermediary calculations or a helper column? I currently employ formulas to determine the day difference between the start date and the set date, and then divide this figure by 7 to derive…
-
If date field is blank formula
Currently, I have this column formula and it works well. =IF([Grant Status]@row = "Inactive", "", IF([End Date]@row = "", IF(TODAY() <= [Start Date]@row + 90, 3, IF(TODAY() > [Start Date]@row + 90, 4)), IF(TODAY() >= [End Date]@row - 90, 5, IF(TODAY() <= [Start Date]@row + 90, 3, IF(TODAY() > [Start Date]@row + 90, 4)))))…
-
Displaying who the current user is on a dashboard.
I have some dashboards set up sharing reports set up for current user. I'd like to include a who the current user is at the top of the dashboard. Thinking there is a way to use a metric sheet.... Would appreciate any thoughts on how to do this. Thanks, Sara
-
what is wrong with my formula join collect?
=JOIN(COLLECT({Rollup Tracking: Preceptor Activity Month}, {Rollup Tracking: Preceptor Activity Preceptor Name}, [Preceptor Name]@row, {Rollup Tracking: Preceptor Activity QTR}, Qtr@row, {Rollup Tracking: Preceptor Activity Year}, Year@row), CHAR(10)) I cannot see why this doesn't work…i have similar formulas on other…
-
Converting a date/time text format to a simple date format
Hey everyone - I am trying to convert a text field that reads 2024-09-25 15:35:27 to a simple date format, either 2024-09-25 or 9/25/24. I've tried using a helper column to just pull out the text date string - =LEFT([Registration date]@row, FIND(" ", [Registration date]@row) - 1) in the hopes that would be convertible to a…
-
Counting with Multiple Values per Cell
Hello! I'm trying to count the number of times a word is used in a column. The column allows for multiple values per cell, but my formulas only count one of the words in the cell and not both of them. For example, the values in the column are Yellow, Green, Blue, Red. There are times when Yellow and Blue need to be…
-
can i change a cell after a created date is past a certain amount of days?
I have a sheet for purchasing requests. Often time, after a purchase is received, the purchaser will forget to change the status dropdown from ordered to received. Is there a way to use automation to change status from ordered to received when 90 days have passed from the created date?
