-
Why won't my automation to record dates work?
I am trying to record a date for each of our statuses listed below. Approval Pending, Approved, Denied, In progress, Completed, and Removed Most of these statuses are updated by a formula when dependencies are met on my sheet. The formula for the statuses is working correctly, but for whatever reason the In progress,…
-
Help converting an Excel formula to work in SS
I've inherited an Excel spreadsheet that is currently uploaded via DataShuttle into SS. However, I have to add six columns and formulas in Excel prior to completing the upload via DataShuttle (data is exported to Excel; six columns are added w/formulas; then DataShuttle moves it to SS). I can't figure out how to convert…
-
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…
-
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…