-
help on formula.
trying to get this formula to work. NO LUCK please advise =IFERROR(WORKDAY(INDEX({delaware}, MATCH([Calendar Year]@row, {year}, 0)), {Holiday}, "")
-
Formula preventing manual entry to cell. Is there a possible workaround?
Maybe a little long, but some backstory is necessary to get a better understanding on what's going on and if I'm approaching this issue right. Currently my Smartsheet is setup where there is a formula in the "Status" column that checks if there are less then 2 names in the "Total Emails per Application" Column. The "Total…
-
IF Formula comparing SUM values
I am struggling too figure out how I can make this formula work: =IF((SUM([Billable PM Hours]@row, [Billable Consultant/Developer Hours]@row)) > (SUM([Consultant/Developer SOW Hours]@row, [SOW PM Hours]@row, 1) Intent is to have these Sums compare to each other so that when Billable Hours Sum is over the SOW Hours Sum, the…
-
COUNTIF with multiple select dropdown column
Hi, This has me going mad! 🤬🤣 I have a sheet reference "Business Area" which has a column type of dropdown multi-select. I'm then using a COUNTIF on specific values to compile a metric sheet. This is counting fine where the dropdown has "C" and "E" selected: =COUNTIF({Business Area}, @cell = "C" + CHAR(10) + "E") However,…
-
Multiple IFs combined with Countm formula
Greetings, I'm currently attempting to write a formula to provide variable outputs based on a Countm function(column in my smartsheet that has multiple dropdown options). What I'm looking to do is have a single formula that will take the result of a Countm on my "corporate objectives" and output a percentage. In the…
-
Calculating Schedule Health - RYBG
Hello, I am a beginner Smartsheet user and I have listed my set of requirement to track my schedule health task. The requirements are based off % Complete and % Time Elapsed. Requirements below: Tasks that show status of “Complete” - Blue Status in progress, where the % Complete is greater than or equal to Time elapsed. -…
-
How do you link certain information from a form to a sheet or report?
I am trying to link certain information from a form to another sheet. The form is a questionnaire with a Likert scale from 1-5. If the user select a 1 or 2, they are required to put in a comment. The comment is another question which shows as a column on the sheet. And lastly, the user who is filling out the form will…
-
Data Migration/ Data Shuttle between 2 sheets
I have 2 sheets Sheet 1: Projects pending approval Sheet 2: All the projects that have been approved I want to build functionality where when I check an approved box in Sheet 1, it will automatically push to Sheet 2. There are a couple issues/ complexities. One of the biggest issue is that the Sheets have different column…
-
Adding Days to a Date Based on a Condition
Hi I've trawled the forum for previous questions but can't seem to see one similar to what I need. I have a date column that I want to auto calculate based on a condition within another column. If [Corrective actions to be completed] = "Immediate" or "5 working days", take [Corrective action chaser 1] + 11 days, if…
-
formula for +40 days after Q
hello, thank you in advance i am looking for a formula to auto calculate 40 calendar days after end of quarter. which does not include holidays or weekends. thoughts? Thank u