Formulas
Discussion List
- Hi, I am trying to track the number of times a call occurs within a date range in a cross sheet reference formula. The user types the date on the call log and I would like to use the dates as a way to…
- Currently I have a form which helps me capture the First and Last name of the user among other information. The first and last name is captured in separate columns. However, 1% of the user inadvertent…
- Hi there, I am after two formulas: FORMULA ONE I need my % Complete to reflect the Status, example below: 0% equals status - Not Started 1 - 99% equals status - In Progress 100% equals status - Comple…
- Hello, I am attempting to recreate a formula I have in Google Sheets to return a quarter number based on the Month. Ex: If a cell has "March", it would be Quarter 1. The original formula involved =IF(…
- I have a sheet that I collect our vehicle information on each month. I manually move new rows to under the correct parent row. The issue I'm having is I can't find a formula to collect the most recent…
- I'm trying to count the number of times the issue "- Originating Agency should be the origin of funds for University pass through funds" appears on a scrub report. I was using a simple count if statem…
- Hello - I am having trouble converting an excel Ifs formula into smartsheet. I am able to get a single If formula to work, but cannot link them to each other - or even know if it is possible. Full dis…
- I want to calculate the Start Date of a task using a simple formula. This is the Start Date column that interfaces to Resource Management, so that task and calculated Start date will be populated on t…
- I am currently working on a project where I would like to set up automated reminders based on the Ebbinghaus Forgetting Curve to maximize information retention for my team members. I plan to use the f…
- I have this formula that is returning INVALID OPERATION =IF({AMR Location} = "Baltimore Mfg", AVG({AMR Level}), "") The Location column is just text. The AMR Level is a number that is calculated from …
