-
Change to formula
Hi, I currently have a formula that looks at a date range and outs in auto test in a different cell. =IF(NETDAYS(TODAY(), [Expiry Date]2) < 0, "Due Now", IF(NETDAYS(TODAY(), [Expiry Date]2) < 30, "Due in Next Month", IF(NETDAYS(TODAY(), [Expiry Date]2) < 90, "Due in Next 3 Months", IF(NETDAYS(TODAY(), [Expiry Date]2) <…
-
Need to Display image attached to sheet in Dashboard - is this possible?
I need to create a dashboard that shows a continual stream of upcoming new products. I can create a report easily enough that will show this info but I need to include an image of each new item along with the data. Is there any way to do this? Alternatively - is there a more "visually appealing" Dashboard design or…
-
Can't find forms as columns
This is my first day starting with SmartSheet so forgive me if this question is embarrassingly simple but I can't seem to find a video or an article anywhere which explains this. I selected a project management template and dowloaded the PDF instructions. One of the first things it asked me to do was to edit the form…
-
project management
We are a land developer. We currently have two large projects underway. https://stdavidsprings.com/ https://redhawkj6.com/ We are experienced with Smart Sheet and use to aggregate data via Zaps and internal data to dashboards to manage our sales group and advertising and marketing impact. We will contract with four…
-
Reverse sorting an auto-number sheet
I have a sheet developed for creating purchase order numbers using the auto-number system. Due to the fact we create a lot of purchase order numbers, I have reverse sorted via the auto-number column so users do not have to scroll through many po's to get to the bottom of the page. Is there a way to automatically have an…
-
2 Conditions on 1 Status Indicator
I’m working on a project where I need to have to 2 conditions on 1 status indicator. * 1 for tracking duration against today's date: =IF(NETWORKDAY([Start Date]9 + 1, TODAY()) / Duration9 <= [% Complete]9, "Green", "Yellow") * 2. Tracking if a task is not completed on time: =IF(AND(TODAY() >= [End Date]10 + 1, [%…
-
Dynamic View & Alerts and Actions
I have set up Alerts and Actions in my source sheet, but I have not shared the source sheet with process partners - instead, they have a Dynamic View I'd like them to look at instead. Can Rules and Alerts apply to people who are not shared with the source data? I keep receiving emails about Invalid Recipients and I'm not…
-
how to count/sum boolean data formula
Hello my firends! How have you been? Would be possible to have a logical formula to checks whether a bollean range and than return that sum of them. for example: if I got two lines with 4 stars the formula should identify into the range both lines and returns 2 as total
-
Enterprise Edition - User Management
Does anyone know how user management works in the enterprise version of Smartsheet. I am needing the ability to manage all user access, and not allow individual users management access.
-
How to change Work spaces Ownership
Hi, I am having some trouble with changing the ownership for workspaces between licensed users. I am an Admin and have workspaces that I now own but need to transfer to someone else to own. I don't want to transfer all my workspaces, just a few . Thanks,