-
Formula returning "invalid column value", but it looks correct.
I used the AI formula generator in Smartsheets and I'm still getting an invalid column value error. I can't figure out why because there is data in the column. If the IMP/DISC column displays Implementation then I want the value from the Implementation Status Update Date to show. If the IMP/DISC column displays Discovery…
-
Need Help with Task Health Formula
Hi - I'm trying to write a task health formula with the following criteria and am hoping someone can help. Here's what I'd like it to calculate: BLUE (NOT STARTED): If the start date is in the future and if the % complete is 0 GREEN (ON TRACK): If today is less than 50% of the task duration and % complete is more than 50%…
-
Add Summary Value from Sub Tasks
Hi all, I have a project tracker that has been created from a project template then manipulated. The template was pre-programmed to calculate/populate the summary value for the Preparer % Complete column but I would like the Reviewer % Complete column to have a Summary Value as well. Is this possible? Thanks in advance!
-
Trying to apply an AVERAGE IF formula
I am running the Employee Pulse Check template for a project survey for our installer team. In a nutshell, form submitters will use a drop down to select which installer they had for the project, and then rate them on 5 questions. I need to average out the ratings for the 5 questions, per installer. Columns I would like to…
-
Automated Workflow - Move row to Sheet (with Index Match Formulas)
Hi there, I have a automated workflow where I have multiple source sheets copying rows into a separate sheet. Since the copied row information on the separate sheet can change on different columns, I have a Index/Match set up to auto populate any changes from the source sheet. The problem I'm having is there is another…
-
Count special characters in a cell
I'm wondering if it's possible to count special characters in a cell, created from a cell formula Count String Occurrence in a Cell — Smartsheet Community What I'm currently doing is adding a period to a JOIN(COLLECT function which I am counting the periods. See below: =JOIN(COLLECT(Post$1:Post$300, [Position…
-
Need help with a master report to create conditions within a calendar.
I am trying to create a master report where it shows vacation days for the team as well as due dates for the projects they are working on. With that being said, I would like for the start/end date to show on the calendar for vacation, but ONLY the end date to show for the projects since they are usually pretty long…
-
Formula for checkbox when date is previous month (and considers previous year in Dec)
How can I alter this formula so that in December of each year, it only considers December of the previous year? As it stands, it's pulling in Dec '22 data. I only want Dec '23. =IF([Payment Date]@row = "", "", IF(MONTH([Payment Date]@row) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1), 1))
-
COUNTIFS with multiple contacts in the same cell then reference a second column
Hi, =COUNTIFS([24-7 PM]:[24-7 PM], HAS("Jon Cornwell", @cell), [Project Type]:[Project Type], "LV Switchgear") I am trying to create a summary which shows how many of a certain project type a project manager may be involved in. Hope that makes sense I can get the first part of the formula to work on its own..…
-
SUMIF ?
Can someone help with the correct formula for the following: I need the JO Volume column sum if the PO Forecast Month column is marked 01-January. Below is what I have so far, but it is not working. I appreciate the help - thank you! =SUMIF([JO Volume]1:[JO Volume]40, [PO Forecast Month]1:[PO Forecast Month]40,…
