-
counting date
How would I go about counting a column of dates and counting each by month and year? Ideally i would like the formula to scan an entire column for all dates in jan of 2018 and return a count of them.
-
Spell Check in Free Text Fields on Smartsheet Forms?
Is it a browser setting, or would it come from how the Smartsheet web forms are built, but I would like for a misspelled word to get the red underline when my users go to fill out a form that populates my sheets in Smartsheet. Help?
-
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, [%…
