-
How do I create a condition when a specific drop down item is selected that an email is sent ?
Using a moble app, VSI (vehicle safety inspection) I would like the ability to have an email sent to my Fleet group that alerts them when certain drop down items are selected. For example, if there are issues with the brakes and they select "Problem, Requires Attention" or when they have an expired registration or…
-
Lookup returning no results
I am trying to have a LOOKUP formula return a result based on the status of a checkbox. I have tried to forms - one by having it look for "0" and one by creating a secondary column that reads the checkbox and returns a "Complete" or "Not Complete" status. Neither will return a result. I have attached a screenshot here…
-
How can I link Columns to update?
Hi, If I have a column named "Status" and within that column there options from a dropdown to select Open, Closed or Denied, once I select Closed or Denied, can I on the same sheet over in another column named "Date Closed" can I have the current Date entered in and that row is closed. Is this possible and if so, how do I…
-
How do I remove erronous contacts from the All Contacts repository?
I am the Admin on our company account. I have updated the User Management and My Smartsheet Contacts with the most accurate employee list. When I am assigning out or updating tasks, there are still erroneous and duplicate contacts in the All Contacts list. How do i remove them to avoid confusion? Thanks!
-
Smartsheet Maps - Marker Label & Details
I used to click on a pushpin and the marker label etc used to show. Just recently this doesn't seem to happen. Anyone else with the same issue?
-
Archiving Workspaces
We have just started using Smartsheet to manage our IT Programme. Each project has its own Workspace. I am just investigating the best approach to archiving projects when a project has closed. We will need access to view the project information from time to time but would not want the Workspaces to clog up the current…
-
Sheet Schema & Report Schema Documentation
Hi, I would like to recommend the following enancement. Please could the be a way to export as an Excel or Google sheet the Sheet Schema. This should contain all the information and properties of the sheet, As per the Properties Dialog box from the Sheet menu Plus all Field: * Column Name * Column Type * List Items * Also…
-
email alerting + webforms
Hey All Hopefully someone can help, i have an interesting requirement. i am looking at using smartsheet as a means of recieving "errors" from clients and then actioning the investigation. I would like to be able to create kanban lanes in card view ( easy ), i would then want to create a webform that would feed into each…
-
Desperate for help with a formula
I need help with a formula. I want to look at a revised date and the original due date, and have the value that is greater in another column for formatting purposes. Here is what I am using. =IF(([Revised Due Date]734 - [Due Date]734)>0, [Revised Due Date]734, [Due Date]734). Can someone help me ? Thanks, Sharon
-
Countif Tasks are completed late?
Hey There~ I'm trying to count how many of my tasks are being completed late and I'm struggling to do this. Here's what I got: Here is the formula: =COUNTIF([Completion Dates]:[Completion Dates], >[Due Dates]:[Due Dates]) This returns zero but I want it to return three. However, =COUNTIF([Completion Dates]1, >[Due Dates]1)…
