-
Help with Countif Function Referecing 2 Columns on a different Sheet
I want to be able to see the count of Projects that are assigned to a specific person in one column and have a status of complete in another column. Not sure what I'm doing wrong? =COUNTIF({Master Task & Project List Range 1}, "Crystal Oliver", {Master Task & Project List Range 2}, "Complete") Am receiving "Incorrect…
-
How to combined VLOOKUP and SUMIFS
Hi everyone, I encounter one issue creating formula and linking between two different sheets. I don't know which formula to use but let me share with you what I have done and if you all have a solution to my problem, that would be great. I'm working on a financing sheet, it will be a lot about proposed cost, final cost,…
-
Autofill is working on some formulae in a row and not others
We have been using SmartSheet for about 3 years and have recently developed an approach for our project managers using SmartSheet. We are about to roll it out to our staff but have found an intermittent behaviour that is most troubling. Sometimes, just sometimes, when we insert a new row or add a new row at the end of the…
-
Commission tracking
Good morning Smart Sheet community. I have been tasked to create a commission tracking smart sheet for our sales team. If you have a pre-fab sheet(s), and willing to share, I would be forever grateful. Otherwise, here was my thoughts on said sheet. First sheet would be for the actual sales. This would have a form available…
-
Formula help
I am needing to calculate total square footage, and if that total is less than 2, I need it to round up to 2. THEN multiply that # by a quantity cell See that attached screenshot... Upper 1 W x Upper 1 H (if total is less than 2, = 2) * 144 * QTY Any ideas? Thanks
-
Using formula in a Date column, then using SUMIF to total
Hi all, Relatively new to Smartsheets and I am looking for a bit of guidance here. I am trying to put together a 'Resource Forecasting Tool' for our company, wherein the users can populate either an 'Personnel Discipline' or 'Equipment Item' to forecast, they then will enter the start and end date and the quantity…
-
pull most recent entry from a column
I have a database sheet which is filled out using a form. It records many different items being checked in and out using a Barcode column and a Location column. The sheet auto fills the date that the entry is created, newest at the bottom. Is there a way to reference the most recent location of any specific item onto a…
-
#Invalid Operation - Error
I have a issue that I just can't figure out. I have 2 identical Smartsheets one was saved as new from the other. I have the same formula in the same column in the 1 Smartsheet example I get a #INVALID OPERATION (Red Arrow) however in the 2nd Smartsheet example (Blue Arrow) the formula works In the attached I have provided…
-
Time Since New
Hi Guys I have a column that shows when a ticket was created in Smartsheet. Now we just want a column that shows many hours have passed since the ticket was created. What formula do you use to show the number of hours passed since created? We have a Zapier zap hitting the sheet to wake it up every hour Thanks!