-
Creating a Formula to track inventory
Hi All, i am trying to track inventory and alert appropriate personnel of when they should order more parts according to lead time. For the most part everything is working well. However, when parts come into the building and are added to inventory my formula still deducts anything that was sent previously. i am assuming…
-
Auto-populating between two sheets
I am currently working on creating some sort of link or equation, that could allow me to create a "directory" sheet where the names in the primary column could be linked to another sheet so that all the names would automatically become options in a drop-down box for another sheet. Is this possible at all, or is this a…
-
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…