-
Trying to connect a check box column to a completion date column
I am looking to connect a column in which I have a check box indicating done (check) and not done (unchecked). On the same sheet I have a column for Completion Date. I would like the sheet to auto-populate the Completion Date field each time a check box is checked as done. Is that possible?
-
Opening a link to a sheet (Smartsheet), while utilizing the Smartsheet App
I have employees that exclusively operate within the Smartsheet App (iPhone & iPad). The sheets that we are working with, contain hyperlinks to other sheets. Upon opening the link to another sheet, while in the app, it redirects the employee to the web version of Smartsheet...it does not open the link in the app. I am…
-
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…
-
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
-
Cell linking within the same sheet
I have a project where I have a start date and due date for each of my tasks, however on a calendar report sometimes I want the start date to show up on the calendar (when it GOES to reviewers) and sometimes I want the due date to show up on the calendar (when the analysis needs to be COMPLETED). I've created a summary…
-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
-
ENHANCEMENT REQUEST: FROM YOUR CUSTOMER BASE
Open Topics Pending Product Reply on: * Fix the link to sheet bug not showing as a URL/link * Unable to unlink, delete and retype in text to fix * Ability to chance the background color in a Sight other what white/grey - fix to allow users to select a color or image upload * Ability to make widgets transparent and just…
-
Help with check boxes
Hello, I am trying to figure out the formula to get a check box to auto check when two other boxes are checked. In the image attached, I'd like to link the check Boxes in line with Person 1 and Person 2 to the check box in line with President Elect. How do I do that without linking all the other lines? Thanks
-
Outlook 365 Integration
I'm running Office 365 and within my desktop Outlook I have highlighted an email that I want to attach to a row in Smartsheets. I have the icon in Outlook "Add to Smartsheet". I open that icon within Outlook and I search for the Smartsheet. I navigate to the appropriate row and I can view all of the columns & data in that…
-
Display predecessor task NAME
We would like to write logic to display all predecessor task NAMES in a new column. So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the predecessor tasks. Anyone done anything like that? Thanks Robin
