Hello Smartsheet's community! I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fi…
Hi all, I have 2 sheets: 1) working sheet where all tickets are logged + their status is maintained 2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated …
I'm trying to find the max value between all the strength columns and have it return the column name of the max value. I've tried the following formula as suggested by AI and other articles I've found…
Help! I need to finalize a formula to return a value of "Yes" if one of two AND statements are true. I am not getting an error with the formula below, but it is not returning a value of Yes or No: =IF…
I'm looking to create a formula to have a cell show a date for when our next delivery comes in. Typically these deliveries are every Tuesday, but sometimes they are late by 1 day, or we skip a week be…
I am looking for a formula to count Children tasks that meet specific criteria. I want to see how many tasks (Children only) do not have a task owner and a "LM" flag is set. The formula below provides…
I am trying to use the distinct function. It seems like it should be relatively simple, but I am getting an error message. Am I doing something wrong? Thanks
I need assistance on counting all rows that are blank based upon a status column The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")). and I tried using this formula: =COUNTIF({Blank Stat…
Hello! I was wondering if anyone knew of a way to get an average of a column. I know we can get an average of a specific range in a column, however this sheet I'm working on is a survey and there will…
I need to create a formula that filters rows based on several criteria. The formula should show rows between specific date periods for the ‘Date Created’ and ‘Date Closed’ columns. For example, rows …