I am trying to put together a formula to track the amount of money we are bringing in per month per project. Not sure if I am doing it right... Any help would be appreicated. Here is what I am coming up with so far - =IF(Phase30)= "Construction", [Estimate $]30/Duration30) I know they duration is only calculated in days -…
We have a smartsheet with multiple rows of activities and column headers: "PSA Start" and "PSA End" dates. We want to build 3 reports that shows: (1) PSA End dates due in 0-2 weeks (2) PSA End dates due in 2-4 weeks and (3) due in 4-8+ weeks. Can this be done directly from the report or will I have to create calculations…
Hello I'm am wanting to count "green balls" within a range. I have used =COUNTIF([Site Attended]11:[Site Attended]26), "green") I'm have the result #unparsable I am a new user so would apprecate the help. Thank you
I am trying to create a formula that changes the RYG balls to Green if one box is checked out of three columns. Can anyone help?
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
I have created an action date column on all my spreadsheets, I would like this populated by default with today's date. I would then like a report running in the background letting me know if any lines become overdue i.e. in the past - I plan to display this on a large computer screen visible by all users If anyone can…
Hi everyone, Need some help. I'm sure this is a simple formula ... but I'm not Excel (or Smartsheets) savvy enough to figure it out. I have a DATE column, and I have a FLAG column. If the date entered in the DATE column is more than 7 days in the past, I want the FLAG to appear in the flag column. If the DATE entered is…
I am trying to come up with a formula that would count only the parents rows.
We are using smartsheet to track when facilities wihtin the organization are visited. Essentially, we have a form that employees fill out indicating which facility they went to and when they went there. I am have created a report that will show all facilities within the organization that have not been visited in a…
