-
Formula to calculate... This is the Xth time this appears in this column.
Hi, I'm looking for a formula that will tell me what number time something appeared in a specific column... I don't want a count of how many times it appeared in column, rather I want to know this is the 1st time, or 2nd time etc. that it is in the column. Ex: Apple 1 Orange 1 Apple 2 Bannana 1 Orange 2 Apple 3 Grape 1
-
Prepopulating a value in a drop down box based on a formula
I created a formula to prepopulate a value in a 'Status' field based on a 'Done' field being checked. For example. I have drop down status field with the following options: Completed, Not Started, In Progress, Incomplete. I have a separate checkbox field Called 'Done' . I set ups the following formula so that when the userโฆ
-
Using the Created By to populate a Contact Column with the full name rather than email
Hi I am setting up a timesheet and I want to use the Created by Column to populate a name contact column. When I use the formula in Name column to copy what is in Created by, it gives me the email address. Am trying to find a method for it to do this I can't a formula to convert to person and I have made this a contactโฆ
-
Levels formula
Hi all I am new to smart sheets, and I was after the formula for Levels and cross-referencing % to give a result. I have the following code in levels, but I need this to be more intelligent. =COUNT(ANCESTORS()) This returns the Uppermost parent as 0, Next level as 1, last level as 2. Is there a way of looking at the %โฆ
-
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in dropdown
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in multi select dropdownย ? Solving for: How many "Devon's Corner" Leads do we have by Location Type - "Bar" or "Brewery".. If any or both of these options are selected, they should be counted as 1 =COUNTIFS({Brand Type 1}, "Devon's Corner",โฆ
-
IF(AND) statement in Sheet Summary Field
Hello, I have searched and gotten close but no cigar yet! I'm trying to create and IF,AND statement in a Sheet Summary field, (defined as Data Type: Text/Number). I want one of two outputs in the Sheet Summary Field: "Active" when a specific task name has Status <> Complete "Complete" when the same specific task has Statusโฆ
-
Metrics
Hi, I have a dashboard that keeps on updating, how do I see last weeks data (In order to compare)? Is there a way to view metrics every week, to auto-update from a week before? Thank you!
-
SUMIFS by Month
Good day...trying to work on a formula to bring back a summed value for each month and having no luck! I have 100 rows with all differing completed dates and a dollar values...sounds simple? Its not.
-
Cell Linking
Is there any way to stop a cell link from updating at once it has been populated? I am using the INDEX/MATCH formulas to assign a person to a task based off of a state assignment list. Once the task is completed, I do not want that person's name to change, even if the state assignment changes in the future. Any help isโฆ
-
what formula would I need to use for this to work
Good afternoon, I am new to Smartsheet and would like to input a simple formula into my sheet. I have a column titled "Delivery date" I would like to insert a symbol or checkmark or something into another column titled "ENTER MSL" when the date in the "delivery date" column is 14 days or greater. I have tried using IF,โฆ