Formulas
Discussion List
- Hi & Happy Friday, I'm putting together a status reporting sheet and I need to be able to update the previous and latest rows, based on a separate column, in this case the Submission Status column. Fo…
- I feel like I've posted 1000 Index Match questions this year! I have a formula (below) that is returning and individual who has the same Date Assigned field but not that same MLL ID. The MLL ID is sup…
- Hi Community! I have a form deployed to community partners. These partners need to submit a report 1x per month. Of course, some do not submit the monthly report. Is there a way for me to create a rep…
- Hello, I recently received advice on here to develop a formula that lists out all projects that individuals are billing to via cross sheet formulas. The below formula would go into the Projects column…
- Hi, I'm trying to create a sheet for a department production report, This department has 10 sections, each section do different type job but the project is same, i'm keeping all section work in a mast…
- I am trying to sum data as of XX/XX/XXXX of each week. I want this data then to go into a cell and not be changed the next week. For example, on 1/15/24, a sum formula was used to calculate the number…
- Hi. I use INDEX/MATCH regularly, but want to add an "IF" statement and am getting #UNPARSEABLE, and would like your help. I'd like to pull the "F Name" from Sheet 2 into Sheet 1, when the "Info Level"…
- Hello to you, Smartsheet community! I am in need of assistance with formulas. I'm so lost in the syntax that I don't know right from wrong, up from down, HAS or COLLECT 😵. I do not identify as a powe…
- Hiya folks- all arguments work correctly except turning Health the color Yellow when Recommended Due Date is within 3 days of current date and status is not Complete. Here is what I need to accomplish…
- I'm receiving a #NO MATCH error with a simple COUNTIFS formula. I'm trying to get a count of the number of times "Routine" occurs in the column, "Workover Type (Routine, Non-Routine)" (text/number col…