-
Dashboard Request: Track Sub-Task Completion Time from Project Start
We have projects with multiple sub-tasks, and we’d like to track how many days it takes to complete each sub-task from the project submission date. Ideally, we’re looking to create a dashboard that shows: Each project The average number of days it takes for sub-tasks to be completed (from project start/submission date)…
-
Fix #INVALID COLUMN VALUE error when using Index Match in a different column type than source sheet
Hello! I am curious if there is a solve to the #INVALID COLUMN VALUE error I get when trying to pull a value from another sheet using Index Match, and both the source sheet and current sheet have different column types. I am currently using the following formula: =IFERROR(INDEX({OChM - Intake - Intake Meeting Date},…
-
Calendar Query - repeating item automation
Hi there Im creating a calendar for my team in SS - some items are repeating Weekly / Monthly / 1st Wednesday etc. How do I automate that rather than having to type each entry individually ? Thanks for your bright ideas 🌟
-
Project RAG
Hi I have a column formula that works out the project health RAG based on how complete the project is and how the actual end date is tracking against the actual end date (see screen shot below). Some of my RAGs are now blank but, I don't want to tweak the formula in case I mess up the other project RAGs, any ideas how I…
-
Can Character limits be added to text fields, specifically for a form?
I saw the post from 6/18/21 here: https://community.smartsheet.com/discussion/80492/can-character-limits-be-added-to-text-fields However, the formula =IF(Text@row >= 50, "Limit Reached. Please use less characters") is creating an #UNPARSEABLE error.
-
Help with countif formula
Hi guys, i want to count the results on a status column that correspond with entries that are M0 , M1, M2 , M3 , M4 ,M5 and i only want to count them if another column called Wave has a entry of Wave 1 can any one help with this formula please?
-
Looking for formula(s) to determine number of months, weeks, days remaining.
I have a beginning date and an end date. Looking for a formula to determine the countdown but in month, week, day form. i.e. (3 months, 1 week, 6 days remaining until end)
-
Formula for counting unique orgnizations
I'm working on a sheet that counts touchpoints with organizations around our region. Sometimes, we meet with the same organization multiple times a month. I'm hoping to write a formula that can count the number of unique agencies we collaborate with within a time range. We collect the organization (which is also the…
-
Counting status' only when certain criteria is present
We are trying to create a formula that will count if 'Update Required' or 'Ticket Opened' or 'New Document Submitted' is found and 'SBR' is found in another cell Goal is for us to understand that from the SBR items, we have X amount of items pending This is what we are using but i think it's counting things incorrectly…
-
Help with index/collect (or maybe something else?)
Hi, I am struggling with index collect. I'm wondering if what I'm trying to do may not be possible with Smartsheet but I'm not giving up until I ask you wonderful people! I have a large Smartsheet with many columns and I'm maxed out at 381 columns, my license is only to 400 columns so while I could probably figure this out…