-
Text to populate when Box is Checked
I need to populate text in a cell when there is a box checked anywhere within a row. This is what I came up with, but it isn't working =IF([Weekend Travel:WeekendTravel]@row = 1, "Weekend Stay")
-
Sum Calculation including a date range
I need to figure out a formula that looks at column ranges 23-Jan to 27-Jan and sums the totals highlighted in blue, if the date range is within a rolling 12 years from the current date. This is the Excel formula that was used (which was more columns): =sumif($DF$4:$GZ$4,">"&Today()-365,DF7:GZ7) I can't figure it out in…
-
Leave cell blank
Can someone help me update both of these formulas to leave the cell blank if the total is 0? Thanks =SUMIFS({Award Total}, {Grantor}, Grantor@row , {FY Awarded}, [FY22]@row , {Status}, HAS(@cell , "Awarded"), {Funding Source}, HAS(@cell , "Federal")) =SUM([FY22 Total]@row , [FY23 Total]@row , [FY24 Total]@row , [FY25…
-
Multiply fields with formulas
I have 2 cells that I would like to take the output of the formula in each cell and multiple. I did the standard formula in the Pay cell but I am guessing due to my formulas in the other cells is causing an issue. Pay rate formula: =IF([Client Name]@row = "Weekend Stay", "$150") Total Hours formula: =COUNTIFS([Saturday…
-
Count If formula using cross sheet reference
I've inherited a massive sheet and leadership has asked that it not be modified. There are 5 "actions" per row. I'm trying to count if any of the 5 actions are classified as "high" significance. The goal is to chart the number of "high" actions by function. =COUNTIFS({DD Input sheet - system team function}, "franchise",…
-
Form Issue with reloading/submitting after submission?
I have a form that submits to a grid that has been giving me sporadic results for the staff who use it to submit data. They can submit a form and sometimes the form will grey out on the browser or it will submit, but to me doesn't look like it actually reloads and leaves the user at the bottom of the form. The grid only…
-
Formula for Metric Sheet - Dashboard Chart
Hello, I'm trying to create a metric sheet calculating statuses per Project Manager. I want to use this create charts on my dashboard. I want a pie chart for each Proj Manager showing the three statuses. I think I know how to create the chart if the data is there. My sheet looks like this: I think I'm almost there, but…
-
Need to Sum Multiple Column Check Boxes
I am trying to sum 2 different column's checkboxes and put that number into a different cell. I have tried a bunch of different ways and nothing seems to work. Below is one variation that I have tried and can't get it to work: =COUNTIF(AND[Saturday Stay:Saturday Stay] = 1, AND[Sunday Stay:Sunday Stay]=1)
-
Formulas for calculating total time
Hey everyone, I am newer to Smartsheet and I am making a form from previous data to continue time tracking. I am trying to get the sheet to add all the hours together from one day to make a total time. It would also be specific to each individual. Each person should be working 8 hours so I should be able to get a running…
-
Asset Management - Due in 7 Days not working
This is part of the asset management template. The stock formula has a category for assets due in 7 days. I wanted to change that to within 7 days, and I looked up this formula that is supposed to do the trick: =COUNTIF({Sheet - Asset Management Sheet Range 2}, TODAY(7)) However, it is still only returning assets due in…