-
Sporadic #INCORRECT ARGUMENT SET error that self-corrects before my eyes
Has anybody encountered this before? The data structure is as follows: Active projects master Completed projects master Resourcing master (some columns use cross-sheet INDEX/COLLECT to pull project data from above two sheets) Resourcing roll-up (columns use cross-sheet SUMIFS from the resourcing master to) I have had…
-
Can there be a character limit to a text field in a form?
And if not, do you know what the character limit is by default for a multiple line text field?
-
Calculating 14 day due date
Hello, I'm attempting to collect training metrics by department and I'm unsure how to incorporate a formula to identify criteria for training due 14 days from today. The below formula references a report with a Due Date column, not sure sure how to create the criteria for due dates 14 days from today. Thank you in advance!
-
VLOOKUP with multiple criteria
I have a VLOOKUP formula referencing another sheet and it works great. The problem I run into is when I need the same formula to look up multiple criteria before returning a value. Current formula (works): =VLOOKUP(Date@row, {BYP RSS Links}, 7, false) I want everything in the formula to remain the same, except I want it to…
-
Automating future due dates, counting cell changes
Using Smartsheet as a task management system for a small team, want to be able to enter tasks, set due dates and notifications, and record completion For Recurring tasks I want to automate the future due dates once it the task has been recorded as completed Current set up Enter form with a 'due date' and if recurring,…
-
Is it possible to change colors within the same row with multiple start/end dates using Gantt Chart?
I am working on a scheduling sheet and have different dates of occurrences on the same row. I would like to have the different dates highlighted in different colors. I am currently manually doing this procedure in Excel. Most of the information I have come across requires each task be on a new line and I would really like…
-
Find end date for a 3 days per week workday
Hello, need help to find end date, the bellow data is available: 1) Start date 2) Number of days to finish the task 3) Non working days are (Monday, Wednesday, Friday, Saturday). Thank you in advance.
-
Index Match Function Not Working
Hi, I have an Index Match Function that is only working for some of the rows and coming up with a "NO MATCH"" for others. It doesnt make any sense to me as it is referencing Auto Numbers that are clear and easy to match. The formula is: =INDEX({Contact List Name}, MATCH([Company Index]@row, {Contact List Index}, 0)) Source…
-
Multi conditional formula affecting the "Status" on a Project Plan
Hi There Can one have a formula in a project plan that says if the "Activity " column is "Project Task" and the "% Complete" 10%, then Status is "In Progress". However, if the "Activity" is changed to "No Longer Applicable", or "Hold" - the "% Complete" remains unchanged, but the Status is then either "No Longer…
-
Help to count a column where neither 'Complete' 'Canceled' checkboxes are selected
Hi all, I am trying to build a formula that references another sheet, mostly focusing on 3 columns in that sheet: At Risk (symbol) | Completed (checkbox) | Canceled (Checkbox) I am trying to count all the values in the At Risk column where neither Completed or Canceled checkboxes are selected. Basically, I'm trying to…
