-
How do I count the number of stars when using the symbols columns?
How do I count the total number of stars when using the symbols columns? I have tried the count formula and it is only counting the number of cells and not the total number of stars, I have tried the sum formula and it is returning 0.
-
Formula to Count Criteria from Multiple Cells
Hi there, I have a reference sheet from which I need to reference two full columns... I need to write a formula to count the number of records where Column 1 equals A, and Column 2 equals B, C, or D. I have been working with =Countif and =Countifs but have been unable to find a suitable method of writing this formula. It…
-
How To Calculate Number Of Days In Month So Far
I am wondering if there is a formula to calculate the number of days in the month to date so I can use it in a formula to calculate a monthly trend. For example, by the 10th of December we have 24 closed deals and we need to calculate the monthly trend to see if we're on track to hitting our targets. With the above…
-
Getting correct number of months between a date and today
Hello, I'm trying to work with a formula to find the number of months between a static date and today for a PTO sheet (see attached). I thought I had the formula worked out, but can't get it to seem to work.. Thanks, -Devon
-
Mandatory Fields on Smartsheets
Hi, Is there any way to make the category field and the risk level field mandatory for users to complete before they can change the status from open to closed in my Smartsheet? Currently we have users who are just closing the status without inserting an applicable category and risk level which is not desirable. I was…
-
Cross referencing formula
Hello, I am trying to reference cells from one sheet into another. My main sheet has a column where only some cells have a value. If the cell has a value, I want it to pull into my other sheet. Is there a formula for doing this? I could simply link the cells, but ideally I'd like it to update automatically every time a…
-
Formula Help
Hi All, I have an approval column which which clicked on, would like to have a tick/cross at the beginning of the row.. Essentially, if CSG Approval (Column 1) is approved, a green tick (as yes in column properties) should appear in Project Approval (column 2) vice versa, if rejected, should have a red cross (as no in…
-
MAX Function Error (#INVALID COLUMN VALUE)
Hello, I am working on creating a project plan. Instead of having the singular Status Update field that comes with the project plan template, I wanted to keep a log of status updates, then reflect the most recent info from that log in my project plan. I created a new sheet/grid with 3 columns. Weekly Comment, (automatic)…
-
Nested IF / AND / OR formula help needed
I need to create a formula which drives the RGG ball in the Contact Compliance Status" field based upon RGG values in the previous 6 columns, based upon the following. Possible Values in the 6 previous columns will be Green, Red, Gray or blank: I've tried several versions of =IF(AND(OR ... but haven't been successful. Any…
-
SUMIFS Formula for Rows Assigned to Multiple Contacts
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now that I have lines with multiple contacts assigned to them it will not recognize even the one employee's name anymore. I…