-
Month not displaying correctly
I have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11:39 AM and the month column returns a 3. The formula I am using works for every…
-
Linking Cells and then Sorting Source Sheet
I am working on creating a master list of events, that pulls data from 2 source sheets. I worked out the linking, but when the source sheets are re-sorted it messes up my links on the destination "master list". Is there a way around this? The source sheets are not able to remain static pages and will be used and updated…
-
IF Statement and Health
I am trying to use the following IF statements for my health column. I get up to IF([Move Complete]@row = "Termed? ", "Red", and if I add any IF statements after that it doesn't work. Can anyone tell me what I am doing wrong in this formula? =IF([Move Complete]@row = "Yes", "Blue", IF([Move Complete]@row = "Termed",…
-
Need Flag or No Flag based on one or both of two columns being blank or within 7 days
Used this formula to get No Flag and Flag result based on the date/whether the cell was blank. =IF(ISBLANK([Date1]2), 0, IF([Date1]2<= TODAY(7), 1, 0)) Now I need to get a Flag if the date in Date2 column OR Date3 column is within 7 days and No Flag if the Date2 column OR Date3 column are blank. I think I got the blank…
-
Formula to Flag or Not Flag
Goal: Flag when the due date is in the next 7 days No flag when the due date is BLANK or more than 7 days in the future Two formulas that seem to work separately: =IF(Due Date2 <= (TODAY() + 7), 1, 0) =IF(ISBLANK(Due Date2), 0) Anyone know how I can combine these formulas to make both work?
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
=upca Barcode Font Encoder
Hey! I need to create UPCa text strings in Smartsheet. Currently we are using an excel spreadsheet that converts number strings into UPCa font values using an excel VBA macro. When I imported my Excel file into smartsheet, this macro was not imported, so the barcode creation functionality is now missing. Does Smartsheet…
-
VLOOKUP Questions
I've got a basic handle on VLOOKUP but what I am trying to do is a little unconventional due to sheet row limitations within smartsheet. We have a sheet in which people will fill in a part number, each part number has a part description. What I want to do is automate the part description field. So I want to use a VLOOKUP…
-
How to setup an "If" with dates involved?
Pretty new to the SS scene. I am looking for assistance/guidance on how to create a formula to check the current date, and compare it to another date in a different column and if the difference is greater than XXX days have it provide a symbol. I have tried googling and have only found a bunch of functions:…
-
Auto Status Change/Update
Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create…
