-
Alternative for Vlookup to search for a column rather than a row
I'm trying to simplify a formula that works, but will become too long for the cell. The Current Formula is =IF([Equipment Max#]@row = "", "", IF([Equipment Required]@row = "FOB", IF(COUNTIFS({EDBFOB}, >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate}, <=[Last Date]@row) > 0, "Error"), IF([Equipment Required]@row =…
-
Trying to accurately gather % complete based on statuses and excluding N/A in children rows
Hi all! I am revamping a project task list template that my team uses each time we are building a new location. We'd like a high level completion status for each department involved in these projects, but I'm running into a bit of a hiccup with my formula. In the Status column of the departmental parent rows, I am using…
-
Is there a way to have a date change in autofill within a formula?
I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for every single line. Wondering if there's a shortcut or something that I could do to avoid…
-
Mitigating users deleting and accidentally sorting/saving rows - will this work?
With all the discussions with multiple editors accidentally deleting rows or sorting, then saving rows so that it messes up workplans, I'm a little scared of what could happen and have already seen it on a small scale, so can't image what will happen when we onboard multiple editors and projects. With my previous MS…
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates - V2
Good morning, This is a follow up question on one I asked yesterday and which I closed before realizing I needed some more help: https://community.smartsheet.com/discussion/comment/289238#Comment_289238 @Bassam Khalil helped me brilliantly with the below formula but there is another variable I hadn't taken into account.…
-
Client name incorrect in Contact List background and will not change
I inherited the Smartsheets/workbooks a couple of years ago, and I recently noticed (on an update workflow request I just created) that a client's name is incorrect. I can not change it. Any ideas where this name is stuck or how I correct it? When I tried to figure out why this happened, I noticed that the name appears…
-
Need Formula: Per Facility per Model #, how much +/- from par level.
I need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or below are we from the Par Level? So something along these lines: Per Facility, Per…
-
Report that not required to manually adding up new project
Hi Team, Can someone help me how to create a report that doesn't require to manually add when we have multiple projects...Is there a way.? Regards, Tanveer
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates
Hi all, I need help with the following: I need to find the contract reference of a person from Sheet 1 in Sheet 2, based on the name of the person and when the mission took place. As you can see below, James had a mission on the 16th of April, so I need the contract reference that corresponds to that date, which would be…
-
Using templates vs sheets in "template set"
Hi, I am creating template "sets" similar to what SmartSheet has created so that our workplan has the same related reports and dashboards for every project. Because we have a lot of users, I like the idea of having the main workplan in a template so that it cannot be overwritten. However, I noticed that in none of…