-
Latest Date from column, if another column contains certain data
I have 2 columns: first column is a multi-select with multiple, the second column are all dates. I want to pull the latest date by each of the items available in the multi-select I figure its some combination of If, Large, and contains. but I'm at a loss on how to nest them together thanks
-
Remove Link but Keep the data
Hi, Is there to keep the previous data if the Reference if deleted. I have this formula =IF(vlookup(referencetoanotherSheer)=x, True). But if the other Sheet is deleted, I want it to maintain the value instead of showing #REF
-
Contact List - Extract last name
Hi Guys, I can extract the first name using =LEFT(Contact@row, FIND(" ", Contact@row) - 1) but changing LEFT for RIGHT doesnt extract the last name correctly in all cases, but does in some. Quite confusing. Not sure here... Contact column has first name and surname combined, separated by a space. I'm trying to separate…
-
Formula that does i=i++
Hi For those that are familiar with programming, I would like to know how to create a formula that does i=i++, in other words I have a column with a drop down list ( State 1, State 2 and State 3) In another column I want to count how many times the State 2 is selected, when people go back and forth through the 3 states…
-
Sumifs with range
Hi, Refer to below, trying to get total sum of certain items. Scenario : Sum numbers from the column, Color, if the column, Fruit is "Apple". I tried below, but returning error. Please help. =SUMIFS([color]99:[color]104), fruit99:fruit104, "Apple")
-
How to count current week for the month?
I need a formula to calculate the week number for the month, for example 28 May 2020 is the 5th week of the month. I understand that week number calculate from w1 - w52. How can I calculate the week number for the month? So basically, the answer will be between number 1 - 5. Thanks.
-
How to have a Date and Time format for Date Column Properties?
Hi, Do we have Date and Time format now for Date columns?
-
VLOOKUP FOR 160+ COLUMNS
Hello Everyone I have created a form with 160+ questions in it then it was summarized in sheets ( see attached "FORM.png") Now that i have those answers , i want them to be summarized in another sheet in rows since the answers have corresponding points to it (see attached "row.png"). y questionisre:. is there a way i could…
-
Assistance with Creating a Formula for Top 10
Hello Smartsheet experts! I have a question that I am hoping you can assist with. I am attempting to build the back-end for a Dashboard widget that displays the top 10 occurrences of a text name that is pulled from the "Name" column in three different sheets (sheet A, sheet B, and sheet C). All three sheets contain the…
-
Metric Sheet or Sheet Summary?
Could someone explain the differences and benefits of using a metric sheet or a sheet summary? I have a project that has several grids, reports, and dashboards, and I need to add some metrics from the grids into a dashboard. I have created sheet summaries, and was using those to populate the dashboard, but have heard that…