-
Prepopulating Form
Hi Smarsheet Community, We need your help PLEASE! We have a master sheet and created a form to send to each line within the master sheet, asking them to answer additional questions. Is it possible to show some of the data in certain columns as a summary or reference for the individual updating the additional information?
-
Today Formula
Hopefully a simple one here. Trying to calculate number of instances / records per day from a date column? Sumif ? Today()?
-
Why is my countifs formula not working
This works =COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023, 9, 30), {Event Management Sheet Range 7}, <DATE(2024, 10, 1) But this gives an incorrect argument error =COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023,…
-
Adding more than 3 categories to PMO template
Hi there! I need to add additional categories beyond the 3 that are pre-built in the PMO template. I can add a category to the intake form and add a column in portfolio metrics but I'm getting stuck on the formula to have it reference back to the project intake sheet. Any assistance would be greatly appreciated! My web…
-
Total "Calculated Total Amount:" column values for all previous matching "CWID"s on same sheet
I have a sheet that collects data from user applications for funding. Unique users are identied by a "CWID" number and the amount of funds they're asking for is in the "Calculated Total Amount:" column at that row. Whenever a new application comes in I want it to search the (same) sheet for earlier entries from the same…
-
How do I report cost changes?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…
-
Countifs(OR
All parts of this works on its own, but cant figure out how to make them work together. =IF($Help$1 > April$1, COUNTIFS({888 - Job Progress Slab}, <=DATE([Help Lot Size]1, April1, 31), {888 - Job Progress Final CO}, ="", {888 - Job Progress Origination Note}, ="Spec", COUNTIF({888 - Job Progress Final CO}, OR(@cell >=…
-
How to add new criteria to the current formula
Hi I have the formula below which is triggering the Manager Approval to Yes if threshold if meet. Right now i need to add another depended which is buyer status which is if cancel then the manager status will be Not Required. Need help on this Current formula =IF([xx Proposed Settlement ($USD)]@row >= {Buyer Supervisor…
-
Countif with Dates
HI all, I'd like to ask your help. I am trying to count the number of items which are planned for particular dates, so the formula should be easy yet.. I get "0" which is incorrect. I need this for my metric to later use it for burn up chart. =COUNTIFS({W2 System Test Tracker Range 1}, [Column2]$2) the bit "W2 System Test…
-
Dropdown selection is this, then this (Formula)
Hello - thank you Looking for help on If Dropdown selection is this, then this. One column is Project Size hoping the next column could display hours allocated. IE: if you select SMALL = 30 minutes , MEDIUM = 60 minutes, LARGE = 120 MINUTES and XL = 240 minutes (and if nothing is selected you get 0 minutes thank you in…