-
Taking Average With Grouped Values
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially,…
-
simple sumif formula not working
Hello, I am doing a cross sheet formula with a SUMIF. =SUMIF({CLONE BATCH ID}, [CLONE BATCH ID]@row, {CLONE CUT QTY}) I am repeating the formula I have used in other sheets. I re-watched the formulas video and am doing everything exactly a I should. Why am I still getting a zero for my answer. It is returning the number…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
SUMIFS within Date Range
Hi, I need help creating a formula to summarize an average using Sheet Summary Columns, I have the following sheet columns: Current Date, Average Rating, I have the following summary columns: From Date, To Date I have the following sheet summary column (locked) for our formula: Total Average Rating I'm trying that the From…
-
How to create pop up text in Smartsheet Dashboard
I am trying to creat an info icon so that when use scrolls over it, a pop up appears to explain the charts in the dashboard
-
When autofilling, prevent autonumbering
Hi, There are codes that I need to use that start with letters and have numbers after them. I want to be able to use the drag to autofill (in the lower right corner of the cell) the rows below it, with the same code. Every time I try, it autonumbers the rows below it which is very unhelpful. For example, my code is RP22…
-
Why can't I have a formula in %% complete when dependencies are enabled?
I just spent a very long time figuring out how to make the %% complete column auto populate based on the dates. I was proud of my work until I had to 'enable dependencies' so that I could have predecessors. Surely it cannot be that uncommon for people to need both. My investors get reports where the 100% complete column is…
-
Trying to find the max value (last payroll Date) from a list with multiple records for an employee
I'm not sure how to isolate the largest/latest date from a sheet that has multiple records with various pay dates for a single individual. The sheet has about years worth of entries for the company. For example, Employee #2 has worked 7 different weeks in the current year on multiple projects, and I want to know the most…
-
Attachments Disappear in Sheet Requires Refresh
Hi, We noticed "Attachments" in a sheet tend not to appear intermittently without any rhyme or reason. When it does occur, a simple refresh corrects the issue. Sheet is shared among three teams, any team member may go without seeing an attachment. However, we've seen where one person can see attachment and another cannot.…
-
CONTAINS with Trigger Search
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device type that contains "Coin". This address will then be checked against the address column until…
