-
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…
-
Index/Match/Max/Collect
Hi all, I am having trouble putting together a formula and I am hoping someone here can guide me in the right direction. We have a sheet that we enter payments we receive from our customers. That sheet has the customer name, check date, deposit date and amount etc. I am looking to create a sheet that can give me the latest…
-
Using COUNTIF in Sheet Summary
I am trying to use a COUNTIF formula in the Sheet Summary. I have a column called, "Current Project Status." I want to count the total number of times the word "Operational" appears in that column. I have entered this into the field with no luck; "=COUNTIF(Current Project Status:Current Project Status,Operational)" I have…
-
Return Blank in column
Hello, I am trying to populate a Pass/Fail Column based of the answers in a pervious column. I am using IF formula, =IF([1. Pass Meds]@row = "Yes", "Pass", "Fail") but not sure how I should add in if blank. Any help is much appreciated!
-
Counting Dates within a Date column
Hi all, I'm trying to set up a formula that counts specific dates within a date column, using the following approach: =COUNTIF({Reference 1}, "31-12-2020") It keeps returning 0 when there are least 4 dates within the target column that match the specified criteria. Can anyone advise how I can fix this? Many thanks in…