-
IF statement
I am working on a sheet and want to incorporate an IF (or maybe an IF AND) statement based on the date items are submitted to them for review, which is one of the date columns in the sheet. Here are the conditions I want to test: 1) If today is less than or equal to 3 weeks from the submission date, turn the RYG ball…
-
iPad Dashboard Navigation
When I create a dashboard, I am unable to create a link to a specific folder within the same workspace that is accessible with an iPad. I've tried it a few different ways (URL's, smartsheet shortcuts, etc.) but whenever I press on the link, it just navigates me back, out of whatever workspace I'm in, to the home tab of the…
-
For project status and risk dashboards - what are your favorite ways to use SmartSheet with Excel?
Hi all, I've reviewed some of the threads on the community here about limitations with Smartsheet not being able to export Harvey Balls or other images into Excel. These icons are extremely useful for risk dashboards and the like. When we registered for SmartSheet, I was hoping to be able to export these things, but it…
-
Help! Percent Complete not calculating
I have a project plan that was sent to me in a Excel spreadsheet that I'm trying to import into Smartsheet; after some trial and error, I've fixed up the fields but even with duration, start, end date and predeccesors enabled, I cannot get the % complete column to populate.…
-
Workflow utilizing data uploader and a template
So here at my company, we have a project template. This template contains many setting, functions, workflows and conditional formats that help organize our information. We currently generate an excel template similar to the one in smartsheets then copy paste into our template. My question is regarding the best way to get…
-
Drop down Multi select
With this new function will this be implemented on the forms as well. Will be be able to select multiple options in one field? Or is this function just on the actual spread sheet?
-
Hiding Completed tasks
I'm using smartsheet to track projects and their coresponding action items. After tasks are completed, I want to be able hide the rows to make the smartsheet easier to navigate. Is it possible to hide rows? I can't tfind the functionality. Any help would be appreciated.
-
Count dates and return a valve from another sheet
I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days Thank you for any help
-
How to Create A Template Set
I've created several project management files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??
-
Hyperlink from Sheet clickable in Metric Widget on Dashboard
We are having people create a hyperlink in a cell on a sheet to a word document saved on our O365 sharepoint. I want this link to then be available on the dashboard. I currently have the cell linked in the Metric Wizard, but when viewing the dashboard, the link is broken and only the words are there. The users are not able…