-
Deciding what rows go on my calendar view
I have done this before but can't get it to work this time. In fact, in my current sheet. However, I can't remember how! I have a checkbox column called SHOW IN CALENDAR. I want the check box to determine what shows in the calendar view. Did I create a separate filter with this before? I just want what I want to show in…
-
Time of day
As an event planner I need to assign start and end times i.e. 9:00 a.m. - 3:00 p.m. to meetings and tasks that need to be completed. I can obviously type in the times, but they do not sort correctly as anything starting with a "1" regardless of AM or PM will shoot to the top. I can put a "0" in front of any AM times, such…
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Delete License User request
A new user at my company inadvertently sent a license request. I can't find an option to delete it. Help?
-
Converting result from an Index & Match formula from date to text
Hello all, I am trying to work on a formula to make it easier for me to work on Global Updates in Control Center easier in the future. I currenly have a formula that coverts the data from Date to Text instead of just a simple link to the (lets say) the Start Date column; I had to do this because of the Global differences…
-
Project sheet - with multiple duration columns
Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve this issue. Regards Daniel
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Calendar App
Hi, I have been using the Calendar App for some time now, but noticed that team members whom have recently got the app have new features that I do not. They are able to custom color code things where my app settings still show just the example tiles and does not give any options to custom color code. Is there a way to…
-
Sending UPDATE REQUEST to External Emails
UPDATE REQUEST to EXTERNAL Emails Problem statement: We tried to send thousands of "Update Requests" to external email addresses using one Smartsheet as the source so that responses can be collated centrally. This is to avoid sending an email to each external email or sending a blanket BCC email to the same addresses. None…
-
Date column formatting
Hi! In regional settings, I can change the default date format for a particular region. I'm not able to find anywhere to change the default manually other than creating another column with a formula. For example, I'd like to just have the date show month/day. Is there a place to do that? Thanks, Richard
