Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Automatic ticket numbering by locationIn Formulas and FunctionsHello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a …
-
Average If Certain Criteria is MetIn Formulas and FunctionsHello, I'm trying to calculate the average number of days but only for columns that meet the criteria. I have a formula that is calculating the networkdays between two dates. This column is called Implementation Time (Days) - BD. I am no…
-
Formula to average a range in another sheet corresponding to cells that contain parts of textIn Formulas and FunctionsI can't seem to beat this formula. I've tried COUNTIF, COLLECT, CONTAINS, and when I'm not getting an error I'm getting 0. I want to see the average of successful deliveries below for all Up to Date emails in Q1. In the sheet I'm working w…
-
Calculating Average Work Days with StipulationsIn Formulas and FunctionsHello, I'm trying to calculate average work days that each command takes to return a request. However, it has to meet several other stipulations. -"Type of Request" has to include "FOIA" (drop-down column multi-select) …
-
Automation with Time selectionIn Formulas and FunctionsIs there a way to allow a user without access to the smartsheet to select a time and date? We use the automation to send emails out to contractors so that they can give us a work start date. However, we also want to know the exact time of…
-
Currency Conversion USD to CADIn Formulas and FunctionsHello I am currently using both currencies in my sheet. I created a column drop down, need help with a formula. If I select USD from that column, the amount should be converted to CAD if I select CAD from that drop down column then the am…
-
Is there a way to Force a Date or Time?In Formulas and FunctionsI am trying to have some date fields auto-populate based on some restrictions. Date Columns 2, 3 and 4 would be dependent on Date column 1. For example: An Inspection must always occur at least 2 days after Work Start. If I enter Work Star…
-
How do I calculate a Group Average for the Most Recent Date?In Formulas and FunctionsI have assessment scores for individuals within different groups (Male or Female). The assessments are taken over time as a sort of "pulse check." Now, I want to be able show a group average (average for all Males and average for…
-
At Risk with % Complete & Dates FormulaIn Formulas and FunctionsOh formulas. . . I feel like I am close, but could use some help. I would like the 'risk' flag to be marked if the data meets the following criteria: % complete is equal to or less than 50% AND The date is within 3 days; Today; or is in t…
-
In URL do you have a special symbole for *In Formulas and Functionsfor exemple In my sheet i would like in my reponse here corresponding with me cell client rfi # info