-
Timelines
Hello Community! Is there a way to make a timeline in days instead of in dates? Like total timeline of 2 weeks as opposed to 1/1/19-1/14/19? Please help me out!
-
Restrict Filter Off Option
Hello there, I reviewed many thread discussions around the Filter functionality within SS, but I still wasn't able to find the answer to my question. Perhaps it got lost and I can't seem to find it, so I'd like to try again... Does SS currently have the feature to only share filters with view only users, specifically, I…
-
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
