-
index and match not working right!
hello everyone, for the life of me i cant get the index and match to give me the data i want to see and i know i have missed something simple. my main sheet is "Master NSW Schedule" (MNS) i have a secondary sheet meant for other users "DETAILING SCHEDULE V2.0"(DSV2.0) this is to hide certain information from them but the…
-
Finding matches with multi-select dropdowns
Similar to the Josh Reilly question, I am trying to match values between a range and a dropdown list. I have a range of poisoned fruit, and a person who eats many different fruits. I want smartsheets to look through the fruits eaten dropdown list and if it finds a poisoned fruit to a) know the status(poisoned/not…
-
Return Column Value based on Current Month
Hi All, Looking for some help on what I feel like you be a very simply formula, that I am over complicating. We track revenue by program throughout the year (contracted rev, delivered rev, billable rev, for Jan - Dec) For our dashboards I am trying to have one column for "this month's contracted rev", "This month's…
-
Urgently need help with a formula!
I have a sheet used to maintain a list of projects, I will call it "Master Project List" and I have a second sheet that the team uses for scheduling which I will call "Scheduler". Team members use a form to enter their planned hours on a project into the Scheduler which includes the project number and the task name. Each…
-
Formula to calculate future annual date after initial maturity date has expired
I need to create a new column date in the future on an annual basis when the initial maturity date has expired. Below are the 3 columns I use to determine the initial contract end date based on effective date and the term. After the initial term the contracts then renew on an annual basis. Every contract period end date…
-
Only use a dropdown list item once
I have a guest list and need to allocate a specific ticketnumber to each guest. But we don't want users of the sheet to select a ticket number twice accidentally. And we like the fact that we can filter to show the ticket numbers that haven't been allocated. Is there a way to dynamically update the dropdown list?
-
Copy and deleting row to another sheet using workflow automation
Hi All, I hope that this question is relevant to the group. Bellow, I have workflow automation that copies the rows on the checked "Resource Forecast" column to the "Stack Rank Capacity" sheet. This automation is working fine, but now I want to find a way that when checked rows change to unchecked, automatically deletes…
-
New Functions Feature Request
"ROW" - used to reference the sheet row number that can be referenced in other formulas. Something like '=ROW@row' 'PREDECESSORS' = similar to current 'SUCCESSORS' function but returns the row references for predecessor tasks in dependency enabled project sheets. '
-
Update Sheet A and Sheet B
Hello Can somebody please simplify this for me. A have sheet A, which copies rows to sheet B be when a checkbox is checked. Sheet B is for the Call Centre (collaborators) I want any action in sheet A to be automatically updated in sheet B As you might know, copied columns are placed at the bottom of the destination sheet,…
-
Calculating Time Between Two Different Dates
I am having some difficulty finding the optimal solution to a problem I am having with Smartsheet. Right now, I have a large sheet which has time on one axis (column A is every date between 1/1/2018 to 1/1/2019). For example, for rows 1/1/2018 - 1/3/18, there is a starting time on 1/1/2018 (example, 8:00:00), and then an…
