-
Countifs formula to count tasks in a range last 7 days to future 7 days
This seemingly simple formula is giving me problems. I want it to count the number of tasks due in the past 7 days through the next 7 days. I am working with the following and getting "#UNPARSEABLE": =COUNTIFS({Owner}, "Joe", {Status}, "In Progress"), {Due}, >= TODAY(-7), {Due}, <= TODAY(+7) I'd appreciate any assistance…
-
If then Help
I have columns with construction bids and the rows are the construction activities with cost. I have 2 years of bids and just want to take the average of the last 6 months of bids for each row of construction activity. =IF([1]4:[101]4 > TODAY(-180), AVG([1]@row:[101]@row), 0) Columns are labeled 1 -101 #INVALID OPERATION
-
SUMIF Not Working
I'm needing to sum of all accounts that begin with R.. I'm using this formula. Is there a different way to sum up the cost for these accounts? =SUMIF([TSA ID #]6:[TSA ID #]206, "R.*", Monthly6:Monthly206)
-
Formula Assistance - Pulling values after delimiter in text string
Hello all, Trying to make a formula that pulls the 11-15 digits following the 14th "_" in the "Ad Name" Column. My formula is currently =RIGHT([Ad Name]@row, 12) however the length of the text I need can range from 11-15. Is there a formula that pulls everything after the 14th "_" that doesn't specify how many characters…
-
COUNTIFS with start date, end date and multiple criteria
Hi all, I tried searching for this and I found a few things that came close but this formula request has a bit of an extra layer. I have a report that is currently achieving this and now I need to write a formula in order to put that number on a dashboard. The reports filter criteria is as follows: If "Status" is not one…
-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
Formula to calculate and copy dates based on form submissions and standard timeframes
I am very new to Smartsheet and I am struggling to find the right formula for a sheet. I am working on a access sheet linked to a form. Different access categories have standard timeframes, for others, the person submitting the form will have to indicate a specific date. I was planning to have a column where to have all…
-
Trying to record time between changes in specific contact names
I am trying to record the response times of two individuals (A and B) when they receive notice of their name within a contact column (start time) and when they can remove their name from that column (end time). Note: there are dozens of other names in these sheets, but we are only focused on A and B. My thought is to…
-
SmartSheet Template Formula Question
Looking at the "project tracking template" In the dashboard view, there is a chart titled "project task completion" When clicking on the visual, I see its pulling from the "sheet - project plan template." But, I can't see what columns and/or fields its pulling from to represent the 63% complete and 37% remaining. I am…
-
Countdown to Launch Days
If today is Jan. 28th and I have a launch date of a project of say Oct. 1st, what formula would I use to countdown the days to Oct. 1 for a dashboard widget? So 246 days, then 245 tomorrow and so on.