-
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…
-
Is there a way to auto-populate a field on a form to match the same field on another form?
I'm trying to create a 3-step, or 3-page, Production Order for commercial production. One page would be for client info, one for script details, and one for editing details for each commercial. I have it set to automatically take the user to the next step once they hit submit. So each step (Parent Row, script, each edit)…
-
Google Calendar
Hi everyone, I am trying to sync my smart sheet with my google calendar, but it appears that only the "Task Name" column comes over. Do you know of anyway to get a column to sync with the Address or Description fields in calendar events? Thanks!