-
Formula or Work Flow to auto populate date in new row every Monday
I have a column for "Current Week" status updates. I'm trying to figure out a workflow or formula that will auto populate Monday's date in a new row in that column - but not until that date is today. ie: every Monday the date auto populates in the subsequent cell of that column (that date addition triggers other cells to…
-
Isblank difficulty
I'm trying to add an "isblank" to this long formula and keep getting a "syntax" error message. Can anyone help? I want to add - if the "End Date" row is blank then this cell should also be blank. Here's my formula without the Isblank: =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), "Red", IF(AND([% Complete]@row <…
-
Weeknumber Formulas
I have a formula set that checks a box if the weeknumber is within the last 8 weeks. At year end, I have to go in manually and uncheck and check the 8 weeks until we are in week 8 of the new year where I can reset the formula since the weeknumber formula does not look at weeks 45-52 as smaller than 1-8, and doesn't see…
-
Index Match does not work for hyperlinks to Smartsheet Item
I use Index Match to pull the project meta data from another sheet and one of the data elements to pull is the Project Dashboard Link, which is a hyperlink to a Smartsheet Dashboard. The link is not being pulled across only the Display Value/Text. Is there a way to pull the link across? I read somewhere that the workaround…
-
COUNTIFS OR - unparsable, please help
The formula below is receiving an unparsable error. Can someone help me figure out how to fix it? What I'm trying to do: I need to count all the email options for the XYZ Business Group. Email could include "Email - Outlook", "Email - Poppulo" and "Yammer Announcement". The email types would be contained in the "Channels /…
-
combine Countifs and OR
Hi - Can't quite get this formulas to work. Not sure if I have it set up correctly. I need a box to be checked if one of two scenarios exist. If the E# is found AND either "UCA approved" or "approved for deployments" is checked. =IF(COUNTIFS({UCA E#}, [E #]@row, AND(OR({UCA approved}, true, {approved for deployments},…
-
Countifs when a cell is blank
Hello, I am getting INCORRECT ARGUEMENT SET on the following formula and I can't figure out why. Please help! :) =COUNTIFS({Machine 1 Serial Number}, <>"", {NS Repair PRV}, "Repair/Troubleshoot", {NS Activity Date}, >DATE(2022, 10, 1), {NS Activity Date}, <DATE(2022, 12, 31))
-
COUNTIF with Parent rows only, exclude children
I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each project manager's sheet. There is a status column using Green/Yellow/Red/Blue identifiers, and children rows need to include…
-
I'm getting an Error - Invalid Value for a formula - Need help
I have Sheet 'A' - which has Office numbers in a Column called Office No. (Column Type - Text/Number) And I want to get Employee Information in a Column called Employee Info (Column Type - Text/Number) The Employee Information is in Sheet 'B' which has the following columns Office No. (Primary Column) = Similar info as…
-
Reports vs. Sheet (reporting / dashboards)
I am struggling because I have a very large SHEET that has many many data points that I have created a REPORT to create a BUDGET summary and projects for Quarterly Portfolio review(s); however, NOW I have to create a REPORT from this REPORT so I can create WIDGETS / Charts on a Dashboard; however, I know it isn't a thing…