Formulas
Discussion List
- Will anyone be willing to help me with formula in smartsheet. I am new user and have lots of problems I would like to sort out. But let me start with the most urgent. I have column 1(SA), 2(SB), 3(SC)…
- I looking for help on a formula that will SUM the column by month. So when I go into a new month, it will sum only the month we are in since the column represents all months of the year. I have a supp…
- I am using form to add row (data) to smartsheet, But newly added row on the top of smartsheet is not included in autosum at the bottom of smartsheet. How I did it was went to the cell at the bottom I …
- Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for o…
- Hello- I am trying to get a formula to calculate if the task is still open and the date is before today's date then the task is overdue. This is what I have for the cell and it keeps returning unparse…
- Hello, I’ve been searching all over the Smartsheet community since last week and was hoping someone could offer some assistance. I have a long Status value that I need to auto populate a shorter value…
- Please can someone tell me the formula I need if a box is ticked how to move an amount to a different column. so If mikes ticks is ticked how can I move the amount to amount outstanding. thank you Sue…
- I am using Blue, Green, Yellow and Red for my project status - I have a formula around it that will change the color accordingly. What I want to do is if the color ever turns Yellow or Red log it as a…
- Does anyone know if there is a way to get a Date to generate when a project is set to approved? I want to be able to set a target date using the time stamp from when a concept drawing is approved to w…
- I have been trying to create a product cost calculator where every column is a finished product and every row is a raw material. I am really bad with formulas but I had success with both Arrayformula …
