-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
Website migration project
Hello, I'm a new Smartsheet user, managing a large health care website redesign project. We have a large amount of content to move from an older CMS to a new one. We're also moving from a static to a dynamic site environment. Are there any users here who have used Smartsheet to manage and track a large content migration…
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
Auto-save no worky?
I've set the auto-save to 3 min. of inactiity. But i get this prompt to save. Am I minstanding how this feature work?
-
Cannot delete more than 5 Columns at a time
why cant I delete more than 5 Columns at a time? seems rather a silly restriction to have in-place?
-
Sending a Row
Is there any way to see the history of ROWS that have been shared? When you send someone an Update Request, its documented in the Update Requests tab with who it was sent to and the date sent, etc. Is there a similar history shown anywhere for the individual rows that are shared?
-
Contact List Column - Export Emails
Is there a way to export the Contact list names and emails?
-
Deleting a Report Item also deletes it in the Sheet?
I came across an interesting interaction today while editing a report. When I went to delete an item off of the report, the item itself also disappeared from the sheet that it was associated with. Is there any way I can retrieve that information and have it back on the sheet but not the report?
-
Publishing Gantt Chart
We have a Gantt Chart, we have many columns for various items and the standard Start/Finish/%Complete....... We don't want to share the sheet with a lot of people they don't need all those extra columns, we really just want to show them the Primary/Task Column and the the Gantt Timeline that is it. Is there a way to…
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…