-
Average of Boxes Checked in Column
Hello all! I have a column of check boxes in which I'm trying to find the average number of boxes checked in a range. I'm trying to use the COLLECT function, w/this formula: =AVG(COLLECT([Photography Needed]2:[Photography Needed]5, [Photography Needed]2:[Photography Needed]5, 1)) When I do so, I receive the error =DIVIDE…
-
How to show "most recent status"
Hi All, I have a "Client Health" column, where I'm using the five hearts symbols to rate the health of a client from 1 - 5. The "Client Health" will get updated every 30 days, based on the current status of the account. This happens in rows 19 - 23 only. In Row 1, of the "Client Health" column, I want to display the most…
-
Using COUNTIF on a Range with Cross-Sheet References
I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet. The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF formula works but this destroys the advantage of using a VLOOKUP formula in the first…
-
Date and/or time stamp solution
We use Smartsheet in many wonderful ways but, in my opinion, the lack of a method to easily lock a cell with a date and/or time stamp is an open door for a competitors raid. A few years ago, I left Smartsheet because images could not be exported with line item details and there was no "key" to associate with a file export.…
-
IF AND date issue
Hello, I hope you can help please. We use Smartsheet to prioritise our workload. What we want to do is to highlight if a task is due this week but we have not manually indicated it as a priority for this week. I have written an IF AND to use a red indicator if the conditions above exist and green if not. It seems to work…
-
E-mail notifications
Hi, I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this all…
-
Replicate Excel Formula in Smarsheets
Any tips on getting this formula from excel working in smartsheets? =EDATE(A2,VLOOKUP(MONTH(A2),'Data Table'!$B$3:$C$15,2,0))
-
Count formula with cross sheet reference/criteria
I’m sure this is easy and I am missing something fundamental. I have searched other conversations but can’t debug my formula. I have a detailed project sheet (that is at max capacity…therefore I have created a separate sheet to do some counts so I can create pie charts and dashboards. I’d like to count the number of sites…
-
COUNTIF Function
Hi All, I'm looking for assistance with COUNTIF if possible. I have a smartsheet containing 3 Rows of multiple flight departures. I need to create new columns which will count the following cells for me: Departure Flight Number Departure Date Flight Arrival Time All of the cells are completed, however when using COUNTIF, I…
-
Alerts For When Nearing 5000 row Limit
Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit? Thanks!