-
Automated Workflow: Change Cell Value (of one cell) to value of another cell
I have a column [H-Interest Code] that has a formula that generates an Interest Code (e.g., ESR: 5000 - High Quality Teams) that uses the [Academic Unit], a drop down column, [Program Code], and [Program Name] columns in the sheet. (The "H" in H-Interest Code refers to "hidden" since this column is hidden.) Formula in…
-
Error for % Complete column
I am receiving a formula error for when a date is entered in a column/cell, set % Complete column/cell to a 10%, otherwise keep current. I've tried using AI for it as well, when generated the formula is still not working. Any ideas? y ideas?
-
Index Match on Headers as Match array?
Hey all In SS, am I able to do something similar as in excel where I can do an index match looking at header names? E.g. Sheet 1 ColHeaders: Country | Apples | Oranges | Pears RowValue1: UK | Yes-Some | No | Yes RowValue2: USA | No | Yes - Some | Yes In another metric sheet 2 I want to be able to show: Fruit | Countries…
-
I need help with a SUM(DISTINCT(COLLECT formula
I am trying to sum the amount of opening in the Openings column for distinct REQs if they have an approved date of January. I keep getting the #invalid operation formula error. Here is my formula =SUM(DISTINCT(COLLECT({Openings}, {REQ}, {Date Approved}, MONTH(@cell) = 1))) Please help
-
Cross reference match formula
I am looking to cross reference Sheet A to pull in Time slots from Sheet B. Criteria I need to have matching from Sheet A to pull from Sheet B to determine the slot number or multiple numbers. Start Time End Time There could be multiple Slot Numbers so it would need to be a multi option that I could use later to separate…
-
need to calculate NETWORKDAYS based on a checked checkbox in a different column "Days Away"
I have a Date column "Date" that lists all 365 days by month. The second column is a Checkbox type called "Days Away" where admin check which days they are away from the office. I need to calculate the total of the days away excluding weekends and holidays counting only the days that are checked in the second column.…
-
Project Mgmt Changing Start Date
Hello, I am trying to create a project management sheet and have a question. I am new to project management as well. The sheet has a start date, end date, duration, and predecessors. If i go to change the start date to an earlier date, I get the following message: Manually changing "Start Date" will result in the removal…
-
Trying to calculate the number of submissions
We just ran a survey in Smartsheet using forms, and its going through the next 2 weeks, i want to gather how many we have received from our survey document and display it on my metrics, to then display it on a dashboard. What formula would I use to do that? I was doing some research but i just keep getting #UNPARSEABLE
-
What formula do I use for my needs?
I have 2 sheets (see screenshots) and what I need is to have the Associate Name from the Associate List sheet copied to a column in the Permissions sheet but only if certain criteria is meet. If there is a date in the Yard Access AND GTDR Expiration columns, I need the Associate name listed in the GTDR Certified column on…
-
Multiple nested IF(AND) paired with INDEX/MATCH ? or other way ?
Hello to everyone. Im starting to go deeper into advanced formulas and sheet reference, but have some issue... I have a "customer activity" sheet, where for each line, there is 2 sets of variables (5 in "activity", 3 in "types"...) and a "Duration" column. I would like to compute the "Final Price", by referencing a "price…