-
Convert Text to Date Format
I am trying to copy a text column written out as "Thursday 07/29/2021" into another cell with a date format "07/29/21" in order to use that cell as a reference. I have tried the VALUE formula but have not been able to get it to work... Thanks for you help!
-
Apostrophe in formula
Aim: I am running a helpdesk in Smartsheet and am trying to autopopulate 'ticket closed' fields for Year, Month, and Week according to a 'date closed' field. E.g. YYYY column: =IFERROR(YEAR([Date Closed]@row), "TBC"). Once a ticket is closed, the YYYY cell should display '2021'. Context: The sheet is a local sheet (for a…
-
Assigning a value to a field
Hello. Could use some help / suggestions on the following formula. =IF(AND([Date Completed]@row = " ", [Due Date]@row >= TODAY()), [Past Due (Y/N)]@row = "True", [Past Due (Y/N)]@row = "False") I have a Due Date field, a Past Due flag field, and a Date Completed field. I would like this process to set the Past Due (Y/N)…
-
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…