-
My Date Helper Row is Showing the Wrong Centure 1923 Instead of 2023
Hi All, I created a sheet where my users will select from a dropdown of available dates. This column is set to Drop-Down so they only can select the dates I offer. (Column Name = Selected Date) I have a helper column that is set to "Date" and has a formula to turn the text data into a Smartsheet date. (Column Name = Date…
-
Apply formula to full column
As lines are constantly added in a workinglist, I want to ensure any new lines will always have a column with a formula filled in. The formula will check certain data in fields on that line to show a specific status/value. I read that i should be able to 'insert' a formula on a full column, but can't find it. I'm only able…
-
Excel Text Formula
Hi, I am trying to use an Excel formula to extract the full month from the date. I am using the excel formula: text([Due Date]@row,"mmmm") and I am getting an error. Is there a similar smartsheet formula ? Thank you !
-
Sum of Values Between Two Dates
Hi All! I am trying to write a formula that add up the total "crew size" required between two dates. I've created a metric sheet to hold the formula. See screenshot of parent sheet below. Formula: =SUMIFS({Shop Overall Schedule Range 1}, {Shop Overall Schedule Range 2}, >=DATE(2023, 9, 1), {Shop Overall Schedule Range 3},…
-
INDEX (COLLECT) Formula returning #INVALID VALUE Error
I am trying to use INDEX COLLECT to pull data out of a specific column from another sheet based one three criteria. My formula is: =INDEX(COLLECT({Site Visit Intake - DOM Review %}, {Site Intake FDC-FW}, FW@row, {Site Visit Intake - DC}, DC@row, {Site Visit Intake - Metric}, [Metric Being Evaluated]@row),1) I keep getting…
-
Combined Multiple IF CONTAINS Functions
Hi, I have the following formula =IF(CONTAINS([Column A]@row, {Sheet A Range 1}), "Sheet A", IF(CONTAINS([Column A]@row, {Sheet B Range 1}), "Sheet B") Now I want to add if both sheets contain [Column A]@row, result: "Sheets A and B", How do I add this last part in addition to my current formula? Any help is appreciated,…
-
Way to get average number of submissions per day?
Working on an intake form with hundreds of responses and I wanted to know if there was a formula to calculate the average amount of responses per day. Thanks!
-
is there a column number function for vlookup?
VLOOKUP requires a number for the column position in the table reference. But I have users who have been known to insert columns into the referenced sheet to the left of the needed column, throwing off the returned value. Is there any function I could nest inside the vlookup where I could provide the column *name* and…
-
formula for status column using symbols based on end and target dates
Hello, I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like: If end date is not past target date then status is green If end date is past target date then status is red Could someone help with the formula? Thank you in…
-
I need a formula to return the most common value in a column.
I need your help to create a formula to return the most common value seen in a column. I have a dynamic list of Names and I want to display the name that appears the most often in a Summary field. Mental block, sorry! I've seen very similar posts but nothing has worked. From this example, I want Joe to be displayed.