-
Round up (multiples of 12)
Hello I would like to place any number in a cell, and in another cell to put a formula that will help me round the number placed in multiples of 12 that is, if I put any number from 1 to 12, my result is 12 for example if I put 22, I round to 24 (since it is the next multiplo of 12)
-
Demo of Business to show managers
Hello, I am trying to explore the resources project planning section. I had a personal for months, but would like to explore the business level. Is there a way to demo the business software? regards, Tom
-
toolbar moved
My toolbar has moved to the top instead of being located on the sidebar. How can I move it back? I can't seem to find the setting.
-
So...What's On The Development Horizon For SmartSheet???
I have a lot invested in SmartSheet with my internal workflows and even client's. I have to know that there are REAL improvements and features coming out to STAY with SmartSheet. Beyond CardView, multi-contacts (negligible implementation) and a lot of UI cosmetic changes that were a mixed bag, not much has improved my…
-
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…