-
Inventory checklist
I have to create an inventory checklit based on an Excel document I will have 2 main sheets: Inventory & Picks Inventory will have a list of all the SKU/units that we have per product. Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough…
-
Combining IF/IF AND Statements
Hello! I cannot seem to figure out how to put together two working IF and IF(AND...) statements. Thank you for any direction on how to accomplish. Sandy If I put "IF(AND..." in front of all the IF statements, only my first two statements work. The rest are ignored. If I remove the "(AND..." from only the first two…
-
Automate RYGB based on Follow-up Date by Week
Community: I have tried but cannot figure out how to make this formula work. Probably something very simple, and I am overthinking. Any guidance would be much appreciated. Thank you, Sandy Scenario: Regardless of the day of the week I open my sheet: If [Follow-up date]1 is between M - F of the current week, RYGB symbol =…
-
SUMIFS Formula
We currently have a SUMIF formula that sums up a Annualized Estimate for a specific Ministry. The Sheet with this data uses a form to populate additional rows. The currently working formula is =SUMIF(Ministry:Ministry, [Ministry Name - Annualized Estimate], [Annualized Estimate]:[Annualized Estimate]) We wanted to break…
-
Interactive Forms
I would like to create a form to collect a variety of information from users. For example, we want to record publications, presentations, and proposals that a faculty member has done in the past month. However, I'd like to keep the form short. If a faculty member has had 2 publications, but 0 presentations and 0 proposals,…
-
If cell fill is a given hex color code, then return value
How can I identify the hex color code for the cell fill options? I want to write an IF statement to return value of 1 if the hex color code is the darkest blue (as an example). A little background.... reporting 6 status stages so the symbols aren't an option. Thanks in advance for your help!
-
Filtering Gantt chart on mobile app
Hi I have a sheet with a number of preset filters, and on my pc, i can apply the filter on the Gantt chart views, while this does not seem possible on the IOS application. Anybody can help with how to do this on the mobile app? Thanks Eid
-
SIGHTS - WOWZA!!!
My workplace just moved up to Enterprise, and I'm loving what I'm learning about Sights! Finally, a place to share information without having to share the underlying sheets. Beautiful work, Smartsheet!
-
Option to Open to Today's Date not saving
Hello, Not sure if anyone else has seen this but when I select the Timeline Display option to Open to Today's Date, the option doesn't save. I need to select the option each time I open the sheet. Seems like a bug or I'm missing something. Thanks
