-
Dynamic View & Dates (in Text Format)
I have set-up a Dynamic View (DV) filter using a helper column that converts a date to a text field display (this was required because DV doesn't allow filtering from a date field). I'm asking it to display items with a start date of today or less (so I can see all active items). Unfortunately some items are displaying…
-
Convert Extracted date from a formula (YYYY-MM-DD) to MM/DD/YYYY
Hello, I have a data upload set from an excel file. It pulls the date data combined with time. I then used a formula to separate the two noted in column "Extracted Start Date" but I need the format to be in a "MM/DD/YYY" format. How can I accomplish this?
-
Multiple IF AND Nesting Formulas
Trying to return a number based on the GVWR column, we have multiple GVWR's and want to return differnt numbers in the TARE column. I keep getting a syntax error and can't figure out why. Ultimately there will be 5 options, showing two below. It works with one IF formula. =IF(GVWR@row = 9500, 5840), IF(AND(GVWR@row = 9950,…
-
Automatic Status (Green, Red, Yellow) depending of two Colum condition
Hi everyone! I'm trying to configure a Health Status condition depending on two colum statuses here the formula "=IF([Health Status]@row = "Not Started", "", IF(AND([Due Date]@row < TODAY(), [Health Status]@row = "In Progress"), "Green", IF([Due Date]@row >= TODAY(), IF([Health Status]@row = "In Progress", "Red", "Green"),…
-
Need an Formula to generate Categories column
We are looking for the Categories to auto generate from the sub-categories multi dropdown selection. We were achieved this by using the =IF(COUNTIF([Sub-Categories]@row, CONTAINS("Fruits", @cell)) >= 1, "Fruits") + CHAR(10) + IF(COUNTIF([Sub-Categories]@row, CONTAINS("Meats", @cell)) >= 1, "Meats") + CHAR(10) +…
-
Multi-select dropdown column to pull single value in another column
Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula for control 4 column ends up displaying a incorrect number "12." instead of "12.1" and control 5 column displays the whole…
-
Generate Documents - New lines in text fields?
Hi everyone, I love the "Generate Document" feature but I have a problem with the text fields for long texts. Even though the Smartsheet cell contains text with several paragraphs, the generated pdf document removes all the new line marks and makes only one big block made of one single paragraph. I checked thoroughly and…
-
Program Health Formula
Hi all, I am looking for a new health formula for my action item register. Ideally, it would have the following characteristics: Symbol would be green if "Due Date" column had a date that was greater than or equal to 30 days away OR if "Completed" column was checked Symbol would be yellow if "Due Date" column had a date…
-
Create Pulse with IF Statement
I am trying to complete multiple IF statement to create a pulse on where a partner is on their project, but am not getting the correct color based on my formula: Here is my timeframe for each phase: An example of one of my formulas: =IF(ISBLANK([Phase 2 Date]@row), " ", IF([Phase 2 Date]@row < TODAY(3), "Green", IF([Phase…
-
Analyst Assigned Projects by Month
Hi there, Struggling with how to set up a formula that will how many projects an analyst is assigned to for the upcoming months. Source sheet has each project name, start and end date and assigned analyst. I'd like to populate a sheet showing each analyst with their # of assignments going out into March 2024. Report sheet…