-
Have a specific cell auto increment up as a new number is added
Per the example below, column "Total UG Footage Complete", I would like have the cell with "50" in it auto increment up when the box is highlighted and I added another 50 for it to show 100. Can that be done?
-
WeekNumber Across Years
I have been able to find success at using the weeknumber formula and combining that with a 'past due' vs 'due this week' vs 'due next week' indicator. I have a separate sheet that identifies what 'this week' vs 'next week' vs 'last week' is by week number so that I just need to change it in 1 place for all of my projects.…
-
IF(ISERROR(VLOOKUP #No Match Question
I am doing a vlookup across multiple sheets and know i will have some #No Match results, however i want to make sure those rows that do not match have a specific response in the cell which is a blank result. How can i accomplish this? Current formula i am using: =IF(ISERROR(VLOOKUP([BE GEO ID]1, {FY21 Radius Partner…
-
Date formulas
I am very new to this and don't work with formulas often. I am trying to create a formula that will update the finish date automatically based on a given timeframe. For example start date is 10/12 next column gives time expected to complete task 6 weeks. I want to create a formula that will autofill the completion date in…
-
How to link same type of multiple data on a single row from one Sheet to another.
Good morning, I have two Smartsheets that I want to link and get some data. Smartsheet 1 has the person's name (and some other info) and Smartsheet 2 has their certificate data. I'll add a Cert column on Smartsheet 1, to link the cert data from Smartsheet 2, however, some names have more than one certs. How can I link…
-
Counting totals with checkbox rows
Hi there, I am trying to set up a formula where it will add up all of the "buying price" column where "sold" is checked. I want to see the total value of all sold units, based on the check box approach. See attached image. Can any body advise how to achieve this? I've been messing around now for a long time, and I cannot…
-
VLOOKUP with conditional criteria.
As mentioned in a couple of previous threads, I've created a complicated cross-sheet formula with several different reports. What I'm trying to do now is have a sheet populate whatever information is found in Range 1 if it meets the conditions mentioned. So, if anything is entered into Range 1 (Outlet) with the condition…
-
Excel Translation
How do I translate this to Smartsheet? =IFS(C3="black",1,C3="blue",2,C3="red",3,C3="green",4) I realize there is no IFS function an that I need to nest the information, but I can not get the formula worked out. =IF[Color]1=Black,"1"
-
Help with formula please
I am trying to sum "Echo Specific CME" that fall between the dates of 5/1/2018 to 4/30/2021 on column "Date of CME". I keep getting an "Unparseable" error. Please let me know what I am doing wrong... My formula: =SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME] >=(DATE(2018, 5, 1), OR([Date of…
-
Dashboards and Graphs
I am using smartsheet as a sort of CRM replacement at the moment and I need to know if there is a way to get my data into a dashboard for some quick reporting. The issue I am running into is that I have the sheet setup to track information for specific data on each row that is non-numeric. Column-Column-Column-…