-
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!
-
Form Reminder
Is there a way to set up a daily reminder via a web form without having to share a sheet with the individuals who will be completing the web form? Scenario: I have a report that needs to be ran daily by a dept. outside of my office. The report should be ran each morning for the data from the day prior. I created a web form…