-
How to extract the time from the system generated date & time
Hello! I'm looking to extract just the time from my system generated date and time, anyone know how to do that? Thanks!
-
Counting Children using OR?
I have this formula: =COUNTIF(ANCESTORS([Schedule Health]@row), <>"Green"). It was used to count theย number of children of a parent row under the Health column if health was green. I now wish to edit the formula so that it counts the number of children if health is green or blue. How can I do so? I've looked up OR but I doโฆ
-
IF Statement Primary Column Work Around
I want to have a Function statement in Smartsheet that identifies if a Date is entered in another field, then an Auto-Number (sort of) is created in the Primary column. So, IF Week Ending = "yes", THEN Week = "prior row number +1"
-
Copying Date columns and making them editable from reports
Hi, Back again with what I hope is a simple fix. Background - I am creating a global project tracker, used to manage and maintain over 2k current projects and ~100 new/ intake projects on a monthly basis. Requirement - The intake form feeding the SmartSheet is asking for a Start Date (intake), Launch Date (intake) andโฆ
-
IF(FIND Function with AND
Hi Everyone, I have created a formula which works well with locating and counting text in a range - "COUNTIF([Functional Area]:[Functional Area], FIND("Accounting",@cell)>0)". This formula counts the total number of items irrespective of the status of the item, which could be for example, New Demand, In-flight, UAT,โฆ
-
Send Attachments using Power automate
Hi Guys, I am trying to send attachments within a smartsheet via email using power automate. When i look on the Smartsheet actions/triggers actions in Power automate i cant see a trigger/action that would allow me to do this does anybody know if this possible?
-
UPDATE: Answered.Form changing a number entry to a % in the Sheet
ANSWERED - Found it from another post where RossL told someone to make sure the % sign wasn't selected for that column. Magic solution. Thanks RossL. I have a form with a question asking "What % of time will be allocated to this project?" When the answer to that question is populated in the sheet, it's coming through as aโฆ
-
Look up 2 columns conditions and return 3rd column value
Hello Experts, I want to look at values from Creation Week and CR_Current Week columns and return values from CR_Start Date. I have given the lookup criteria in Column G2 and G3 and want to return the value in G4. =INDEX(ColumnD2:ColumnD14,MATCH(IF,(ColumnG2=ColumnB2:B14)*(ColumnG3=ColumnC2:ColumnC14),0)) ORโฆ
-
Linking 2 Sheets and Finding the Same Information
I want to link two sheets. Sheet 1 contains multiple columns. (Column 1) Something is marked as approved. (Column 2) Contains multiple product codes/numbers. There are many rows of product codes and multiple approvals. Sheet 2 contains multiple columns as well. (Column A) Something is marked as approved. (Column B)โฆ
-
Looking to create an =IF(CONTAINS Function for a formatted Date field
Hello! I'm looking to create an =IF(CONTAINS function to pull the day of the week into a separate column from the formatted date column. For example: I want the "Event Day" column to turn Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, or Sunday depending on what is in the Event Date column. I have created thisโฆ