Formulas
Discussion List
- I want a tally of the results in {Master-# of Assets} and {VisionHub- # of Assets} from two different sheets (that are almost identical in columns) I want a formula that will give me this tally across…
- Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summar…
- Greetings- I need a formula to select the Alert checkbox if the Remaining $ is under $1,000 left. One time Id also be curious if possible to do this based on a percentage left of the original PO Amoun…
- I have a working formula for task health based on % Complete and Target Completion Date (see below). I'd like this formula to ignore any rows with blank Target Completion Date and display nothing in t…
- Hi SS Community, I created a formula that builds the URL below to pre-fill fields on a form using values from a table. The resulting string works when I copy & paste it into a browser window, but not …
- Hi All, Can someone help me with a formula? I've searched the community and haven't been able to find an answer. I already have a formula in place to calculate the end date based off of the start date…
- Hi, I want to add a formula to a checkbox column, the purpose is to automatically check the box once the cell satisfies two criteria simultaneously. Criteria 1: Phase column=Milestone Criteria 2: Fini…
- I'm trying to create a formula that adds the amount in the "Amount" column only if the "Revenue Period" column contains "2024". When using this formula I get "0".. =SUMIFS("Amount", "Revenue Period", …
- Hi there, I am trying to pull the most recent fee payment value from each regional group. I want this to pull through to a report so that I can see that most recent payment value In a report where all…
- I am trying to count the number of entries per month. My formula for January specifically is below. Can anyone fix this? =COUNTIF({Sourced Date}, MONTH(1))
