-
Multiple columns condtional furmola/formate
Hi , I have fleet of cars my drivers manually on daily basis type the KM/Millage reading in Column (Km/Today) I need formulla for column Alert as follows: - - - - - - - - - - - - - - - - - - -- - - - If number in col (Oil Next) is less than col ( Km/Tiday) the alert Col is (Green) AND If number in col (Oil Next) is Higher…
-
Populating a Multi-Select Column from Excel
I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns. I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this window. :/ I appreciate any and all help. Teri
-
Merged: "mailto:" URL functionality on Dashboards
This discussion has been merged.
-
Input/auto fill data from different rows
Hello, Please find the example photo I would like if there is a formula that can auto fill and input data in blank columns/same row once i type the phone number (in column phone) by calling or looking up for the data from other rows in same sheet (or from other data pase sheet) taht engaged with same phone number. For…
-
Activity Log - Export / Download Options
When an Activity Log is downloaded, the report notes the row where the change has occurred. However, if the Sheet's rows are resorted between the time of the report download and reviewing the report, you can not determine what row the change was made on. I would suggest that the Activity Log download would have an option…
-
Contact List Field in the New Logical Forms
I have a grid with a Contact List Column and I have imported all of my contacts from Outlook, in the grid the field will start suggesting contacts as I type. I created a form from the grid but when I launch the form and start typing in the contact field nothing is populating from my imported contact list, what am I missing?
-
Gantt Chart Predecessors
I recently came from construction scheduling where we used Buildertrend. Their Gannt charts were great to work with and easy to use. They had it where you would manually drag the predecessor arrow to the task that follows, it would stay in place, then you could adjust from there. I dislike how in smartsheet you can link…
-
Info box on a dashboard
I would like to place an explanatory field (black box) on a dashboard, which is activated only by a "mouse over" over an infofield (i) (see screenshot example). Does smartsheet provide this functionality? Thanks for any hints.
-
Merged: "mouse over" interaction on a dashboard
This discussion has been merged.
-
Portfolio Management: Team member part-time availability on Projects
I need the ability to set part-time availability for a team member to specific projects, i.e. working Mon-Wed on Project A and Thu-Fri on Project B. For each project and each team member you could set working days, that would solve this problem. I have a team member in high demand, between two projects an agreement was…