-
Formula with checkbox
Hi everyone, I need help for a formula. I have created an ESTIMATE sheet for my projects, but sometimes clients decide that they no longer wan't some items to be included in the estimated. Instead of putting a 0 into my quantities, because I would lose the quantities number and maybe he would change is mind and decided to…
-
Cross-sheet formula
I would like for sheet to auto populate certain fields based on entering in a "property name" When I enter a property name, I would like for it to access the fields from another sheet that has that property name, and input values for that property. would I use a =vlookup? Thanks for you help! SGF
-
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…
-
#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…
-
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…
-
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,…
-
Using Countifs with multiple references to other sheets
Been playing with this for a while but can not seem to get this right. Any help would be appreciated =COUNTIFS({Editing List-3-2018 Range 2}, >=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, ="Name"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to: Editor],="Name")
-
%Complete forumla reflective of sub tasks Complete
I am looking for a formula that will help me achieve a percentage complete column that will reflect the number of subtasks complete divided by the number of subtasks. For example: Parent folder with 3 subtasks Status of 1 subtask is complete Percentage complete column will reflect 33 percent complete Any help would be…
-
Formula to flag a task if not completed before due date
I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column. Ideally I'd actually like to flag it if the due date is tomorrow or already…
-
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
