-
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
-
Conditional Formatting
Hello, Is it possible to apply conditional formatting only in specified rows or does it only apply to the whole sheet? My example is as follows: I am currently tracking production on 20 units. For the first 5 units I do not care if the duration of a planned task exceeds its target. However for the next 15 units, I do want…
-
Alerts for only incomplete tasks
I routinely send auto alerts 3 days before a task is due to serve as a reminder. I recently began sending another alert on the date that a task is due. However, I don't want to send the alert if the task is 100% complete. I guess that I was assuming that the alert wouldn't be sent if the task is complete. Is here a way to…