-
Find the Percentage of the Total
Hi! I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I…
-
LocationData sheet + TimeData sheet (referential integrity)
I have one sheet that records location data: Location ID (autonumber), Location Name I need to record lots of data for this location over time so it would seem the best way is to add another sheet with: Location ID (reference to other sheet's Location ID), TimeData I know there is no way (which is irritating) to create a…
-
How to link data in two sheets via a report?
Let's say I have sheet #1 called SiteData with columns SiteID (autonumber) and SiteName (text) Let's say sheet #2 called TimeData with columns SiteID (text/number) and TimeData (text) How can I get a report to link the data between both sheets so that it can group TimeData with SiteName via the SiteID? Such as creating a…
-
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…
