-
Assistance Needed - Formula - #INVALID OPERATION
Hello SS Gods, Assistance is needed. So I have 3 columns, Ready to Pair, Not Ready to Pair Date and Not Ready to pair + 2 weeks. The Ready to Pair? field is a drop down list. Once the status "Ready to Pair in 2 Weeks" is selected, I have a workflow set up to record the date in the Not Ready to Pair Date field. I am using…
-
How to show dates in a range for a report, where the date range is between two column dates
Hi, I'm trying to create a report to better visualize capacity analysis for certain time periods. I have one sheet for a team of people where they have put in the estimated time they'll spend on each project within a date range. In essence I want to run a report where I can pull a date range like 9/1/23 -12/29/23 and it…
-
Show ONLY Tasks in a Date Range
Is there any formula and/or filter that will enable me to show only the tasks that are scheduled to happen during a particular 3 week time frame, much like a 3 week lookahead. I want to show tasks that, during the time frame, have the following criteria. Begin and End AND is INCOMPLETE OR Begin AND is INCOMPLETE OR End AND…
-
How to calculate Percent Complete based on multiple columns
Good afternoon. I am new to Smartsheet. I recently imported a tracking Excel spreadsheet into Smartsheet. I have a existing column that tracks percent complete and the formula is =COUNTA(H4223:AC4223)/SUM(COUNTA(H4223:AC4223)+COUNTBLANK(H4223:AC4223)) It comes over as unparseable. Can anyone recommend a Smartsheet formula…
-
count if / v lookup formula
I'm trying to count the number of times the issue "- Originating Agency should be the origin of funds for University pass through funds" appears on a scrub report. I was using a simple count if statement at first but ran into an issue when two issues were reported for one proposal in a cell. I thought a work around would…
-
Need help with multiple If formula
Hello - I am having trouble converting an excel Ifs formula into smartsheet. I am able to get a single If formula to work, but cannot link them to each other - or even know if it is possible. Full disclosure, I am not very familiar with more advanced formulas. I have a column that has multiple entries. I created another…
-
IF/AND Statements to change Symbol colors
I have a column in an equipment check-in/out sheet with Symbols (Red, Yellow, Green, Blue) where I am attempting an IF/AND statement to determine the color. Yellow = OUT box is checked and the date is today Red = OUT box is checked and the date is before today Green = IN box is checked Blue = Maint box is checked Each…
-
Calculate a date based on contract end date and classification
I want to calculate starting work on a contract renewal based on contract end and the supplier's classification. If the Supplier's Classification is "strategic" I need the Start Renewal to begin 540 days prior to Current Contract End date If the Supplier's Classification is "key" I need the Start Renewal to begin 360 days…
-
Calculate Start Date using a formula
I want to calculate the Start Date of a task using a simple formula. This is the Start Date column that interfaces to Resource Management, so that task and calculated Start date will be populated on the Assign To person's outlook calendar. Everything works EXCEPT the Start Date field does not seem to allow entering a…
-
Using SUMIFS formula to add up certain date ranges
Hello, I am in need of a formula that will add up certain date ranges. With every project that is virtually supported, our potential cost savings is $2200. Now, going off of the "Arrival Date" column, I want to add up the projects virtually supported based on quarters of the month. What SUMIFS formula would I use to…
