Reminder for every month task
Hi, Every month, we also help our client (around 1000 ) to prepare monthly financial reports and upload their web site. Some of them has specific date required to upload. In SS, we have total 4 sheets. Each sheets represent 3 month(we can't put 4 sheets into one because limitation of SS:, maximum 5000 rows) . We have one…
Multiple Column Confirmation Criteria to return date from "Order Date" Column
I need a formula for a date formatted column that must return the "Order Date" from the ODate column if the Site Name (Site) is Oak Village, Block Name (Block) is Block 102 and the Floor Level (FlrLvlUnt) is Basement Level. I managed this multiple criteria lookup with SUMIF for number values, but have been unable to do so…
IF(AND Today() with color
Hi Team, I've attached my If(AND(TODAY formula with color. I then set the conditional formatting to look at the row that returned "Red" or "Yellow" in this case. The question I wanted to ask, Can I avoid the conditional formatting and have the code return the color instead ? See attachment Thank You
I am literally new to Smart sheet and feel very lost. I am trying to send out a form for meetings and then they would reply on SS as to wheather they were going to attend or not? I am notified of changes and the responses go to a different row and it does not show date of response or a name? What am I doing wrong?
How to setup a quotation number request feature?
I would like to set up a form where the users will enter the details of a given, and submit. An automatic sequential number is to be assigned to this entry and notified to the user who sent the request using the form. Is that something that can be done with smartsheet?
Approval not sent to self
I have an issue list with numerous people assigned tasks. I use the approval process when ever someone closes an item. The problem I have is that if the owner of that item closes it they have to go through the approval process. Is there a way I can avoid this? would comparing the modified to assigned work?
How do you disable "New! Notification Center" popup?
Is there a way to disable the "New! Notification Center" popup? I have tried clicking "Got It" and "Learn More", and clicking the help icon within the notification center and unchecking "Show Help Tips the first time I use a feature". It still comes up every time I open a SmartSheet or refresh a page.
Project Sheet: Formatting Parent Row based on Children
Does anyone know a way through formula and formatting rules to highlight a parent row cell (finish) if any of its child rows have a blank value in finish? We want to avoid the parent finish date looking deceiving in reports when only some of the children finish dates are known.
Labels for RYG Balls
Hello I am sure it is an easy answer, but, I cant seem to find information. Is there a way of having a label associated with one of the RYG balls, ie when the green ball is selected, the next column says 'Active', The red ball would be 'On Hold' etc.
Compressed (zipped) Folder is invalid
Hi, Since last week if I want to open the zip folder from the download backup link it gives me the following error. Please assist. Y