-
highlight today's date
I've just begun using SmartSheet and like it a lot, but it seems as though my team and I keep running into the same problem in various contexts when using Gantt view. Specifically: It's hard to find today's date. Every time we open a sheet, we first need to make sure we KNOW today's date, and then we spend a couple of…
-
AverageIF help
I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column. I wrote this…
-
Formula Help.
I have a formula going on for the RYG. I added a new column, "Status". I wanted it to be If the status column is FILLED or CANCELLED, the ball will turned Green and canceled out all the other formatting. How can I corporate that into the existing formula below? =IF(TODAY() - [Date Opened]@row <= 60, "Green", IF(AND(TODAY()…
-
sysadmin + groupadmin but cannot edit column properties???
For a sheet where I'm not the owner, but another licensed user in my team is, I cannot edit the column properties. Am I missing something? If not, then this really reduces the collaborative value of Smartsheet Thanks, Arnie
-
Google Calendar
Hello! I am new to smartsheet...learning as I go. I have published my sheet to my calendar, and I have overlayed my calendar to my sheet, however my appointments on my google calendar that is NOT sheet related (ie. speaking engagements, meetings and conferences) is not overlayed onto my smartsheet. My sheet is utilized as…
-
Alert and update based on start date, end date and completion %
Hello, I would like to set up the following for a project plan. Reminder to the person assigned in contact column on the day that the task starts (start date). Update Request sent to the same person on the (end date) only if the task is not completed. Can that be done in one work flow, or is that two separate?
-
Corresponding cells
Greetings, I have an end date column and a delay column in some of my smartsheets. I now need to add some of these delays to one of my duration cell (which gives the overall duration of my project (cell in pink highlight)). Suppose, item A, item B and item C were supposed to arrive on the 1st, 2nd and 5th of a month (in…
-
Change Dropdown Items in Form
Is there a way to automatically remove a dropdown option from a form after it has be selected a certain number of times? I have a registration form and have people selecting a time slot and after that time slot has 6 participants I want that time slot to no longer be available.
-
Contact field on form not working from web, ok on mobile
I have a form that has a contact field (email). It's a required field and the form just recently started acting glitchy. When accessing the form from a web browser, it does not allow the user to type anything and they can only select from past field values. When accessing the form from the mobile app, it works as expected…
-
Report - How to sum the values.
Please, I'd like to sum the values from all rows in a column and see this result as a last row. Is it possible to sum values in a Report?
