-
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
-
Revenue Formulas
Hello I need to take our revenue and break it down into revenue per month, and revenue per quarter and return each value into a separate cell. So take extended sell based on month (I have another column on my sheet called Date Shipped) and add it all up into a cell. Same for the quarterly. I would be open to having the…
-
Resources allocation / staffing at hourly granularity
Hi. we have the need for a tool that will allow us manage short & simple projects (hours/days) for our team. Something like Float.com. As we are using Smartsheet already, i'd prefer to find a solution that utilize SS, instead of bringing to the company another solution. But - I didn't find a way to work on an hourly basis…
-
Need help with a recurring report formula
Hi. I am new to Smartsheet and it has been a while since I have done alot with formulas in Excel. I am setting up a report tracker for our organization that will have recurring reports due on a weekly, monthly, and quarterly frequency. I need some help with a formula to automatically adjust the next due date so that…
-
Automatic blank top row
Hello, Currently when I type into the last row of a sheet it adds a new blank row on the bottom of the sheet. Is there a way to basically reverse this so that the row is constantly added to the top of the sheet?
-
Calendar View
My conditioning format does not show when I view my smart sheet in the "calendar view". Any suggestions?
-
Having link to Smartsheet on our intranet
Hi all! I work in the Communications department and we keep a tracker of all of the events for the year. It used to be an Excel spreadsheet and we put a link to it on our Intranet page for all staff to access. Now we keep it in Smartsheet, and I've only given access to my team. Is there a way for folks outside my…
-
No restrict to dropdown values on form
On the sheet, if I dont check on "Restrict to dropdown values only", then I can type a new value into the dropdown column. But on the form, I cannot type a new value, even I choose not to check "Restrict to dropdown values only" on the column properties. Is there any way that I can create a dropdown field on form and still…
-
This rule triggered itself directly or by at least 1 other rule, which is prevented.
I have a SmartSheet constructed as follows: 1. A dropdown list contains five options to indicate the task status (Column = "Pickup Status"). Pickup Status Pending... Pickup Now Do NOT Pickup Pickup Completed Unable to Pickup 2 . The Foreman will use a form to submit the initial data and set a hidden field to "Pickup Status…
-
Any cell below the stock Level, RYG become to red.
Hi, As per the attached and formula, How can i add the formula if Week 19,20,21~52 any column below the stock Level, RYG to red. I'm only know the formula for single cell. =IF(ISBLANK([Stock Level]3), "Yellow", IF([Stock Level]3 <= [Week 19]3, "Green", "Red")) Thanks in advance.