-
Differentiate sections in master gantt chart with different colors to show different projects
I created a master gantt chart where the beginning and end dates are linked of different projects within one branch of the business. So each line would have columns like the below with the gantt chart to follow. Project 1 | 60 days | 3/1/21 | 6/1/21 Project 2 | 120 days | 3/1/21 | 9/1/21 Is it possible to show a particular…
-
formulas doesnt work when updating data from external source
I'm using Appsheet integration to extend the functionality in forms. I encountered a problem when trying to use the SUM formula - when a data is updated inside the columns from appsheet or another source (i only updating numbers) the formula in smartsheet doesn't recognise it and when trying to sum the numbers it shows as…
-
AVG(COLLECT)
I am attempting to average a column where the assignments are now closed (or past the due date) for the year. The Year@row is 2021. =AVG(COLLECT({Row Averages}, IFERROR(YEAR(@cell), 0) = Year@row, {QAlerts Closed}, 1)))
-
VLOOKUP resulting in some references coming back as #NO MATCH.
I have a master Smartsheet people fill-out a form for that submits purchase orders made. I have a corresponding Smartsheet that people fill-out a form for to indicate when a specific PO has been received. In the master Smartsheet I am attempting to use a VLOOKUP that looks at the PO number from the master Smartsheet and…
-
COUNTIFS Formula Issue
Hi all, I'm trying to count how many times a particular field appears in a range across two different sheets, but I keep getting an #UNPARSEABLE and I can't figure out why. My formula is below: =COUNTIFS({2021 Completed Sim Equipment}, "24 Week Airway Trainer",[{In Progress Sim Equipment}, "24 Week Airway Trainer"]) If I…
-
SUMIFS
Hi, I'm looking to sum the cells in a column if another corresponding column is either of two values. I'm getting #UNPARSEABLE though! 😕 =SUMIFS({Data Range Spend}, {Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”)) Any thoughts welcome! Thanks, Derek
-
Summing FTE Hours available in the future
I am currently utilizing the current formula =SUMIF({Resource name}, [Resource Name]@row, {Weekly Scheduled Hours}) to determine how many hours a resource has available. Since I began using this, some assignments have ended, but resource utilization is still being summed, resulting in weekly hours scheduled being >40. How…
-
Using IF with greater than or equal to a number
I want the "Complete" column to show "yes" if the total reviews is greater than or equal to 3. I cannot figure out what I did wrong with the formula above. Thanks!
-
Nested ISBLANK Formula
Hi I want to be able to look up changes to e.g. employee name, Job Title etc in a sheet and update the any changes on a staff sheet. However, if for example, their job title hasn't changed I need the formula to refer to 'old job title' column. I have a unique identifier of the Employee ID so, wondered if an INDEX MATCH…
-
Using HAS with Multi-Selection Dropdown
Hi, I have a multi-selection dropdown with region selections. Next to that column I have the regions. For reporting purposes I need the column for each region to say "Yes" or "No" based on the items selected in the multi-select dropdown. I've created this formula with a variation for each column: =IF(HAS("Central",…