-
Messaging collaborators
With so many collaborators working at any given time on the same sheet (you can see when someone enters or leaves a sheet), has any thought been given - is it even possible - to having an IM-type feature whereby you could message others in the sheet at the same time? We already have IM software internally which we use…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Setting Conditional Formatting/Formulae(?) for Red Yellow Green balls based on % Completed
Hello, I am trying to have the Red, Yellow, and Green status balls automatically change/update based on the percent completion of each row task. When I click on the conditional formatting button in navigation pane and make new rule of, "If % Complete is between range of 1% and 99%, then change the status column to Yellow"…
-
Contract Managment
Has anyone created a smartsheet to manage contracts?, specifically to perform the below activities: * track total amount vs. payments * track payments against deliverable complete * track contract term * track contract amendments : to extend the period, increase the budget, adjust terms of reference, etc. * Track invoices…
-
Static Date/Time Time Stamp formula
I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day. =IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 = "SERVICE COMPLETE"),…
-
Importing Text Excel Data as Drop List
Hi all - I imported data from a spreadsheet, and some data columns that had been text in Excel became drop lists in Smartsheet. So, for example, I had a column 'Frequency' which had 6 different values such as 'Calendar Annual', and Smartsheet created a drop list with those values. But other columns, such as 'Benchmark'…
-
We need Two Cells to Trigger a final cell location
We need When Med4 Quiz is checked and Med4 E Learning is checked, then All Complete needs to automatically check. I have tried =IF(AND([Med4 Quiz]3 < 0, [Med4 E Learning]3 < 0), 1, 0) ...but this is not working for me. Any help with this would be greatly appreciated!
-
Gantt Chart Due Date Flag / Milestone
Hi, Is it possible to show a 'flag / milestone' as well as the duration bar on one line of data. I would like to have a due date associated with a task, as well as a duration. Such that I can see instantly how close I am to a due date. Thanks
-
Conditional Drop-down list
Good afternoon, Currently, my company is using smartsheet to build up a database of our quality issues. Since the department is new to this, data entered is not very robust: Many auditors simply log in, type in their name, work station and enter text describing issues as they encounter them. I want to take this to the next…
-
Creating an Alert for Attachments
I'm using a Form to collect data that is populated in Smartsheet, and the form asks each user to include an attachment with their submission. I'd like to be able to mandate that the form cannot be submitted without an attachment OR set up an auto-notification to the user submitting the form to submit an attachment if that…
