-
Default view when a user opens a sheet
Hello! What is the default view for a unlicensed user when they open a sheet? (In regards to collapsed and expanded rows) Is it the same as the last way they viewed it, or how the last user had viewed it? Here is the specific question from my colleague: "Usually when I'm done with a set of tasks I like to collapse them…
-
Change Status if Date Completed is not blank
Our team has a sheet to track all of our tasks - who it's assigned to, when it's due, date it's completed, the status (requested, assigned, complete), etc. We have people updating the "Date Completed" column, but forgetting to update the "Status" column to "Complete" (The "Status" column is a drop down column). Is there a…
-
Workflow email content based on conditions/critieria
Hi All I'm very very new to SS (just got a license today) and I've been included in a team to improve the notification process to our wider audience with key information to help them complete actions quicker with minimum TLDR! Is it possible to take the column header and add the text to the output notification (email) if a…
-
Can I setup conditional formatting based on a time function?
Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.
-
Counting checkbox's for children without counting the parent
OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this? If the "Is there a color image?" box then the row will be counted. My goal is to have a total count of images that we have a color version for. the URL is on a row…
-
How to input a date/time and calculate a time elapsed?
I'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is =(Time1-Time2)*1440 which gives me a total time elapsed in minutes. I then build my dashboards to take those calculated fields and do…
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
Forms Workaround: Submit button opens new form to allow sub-info - How do I stop when user is done?
Please help! I'm stuck. Goal: Create a form customers can use to report a problem with an order. The order may have more than one line item (i.e. Customer ordered 5 received 3 of product #1-ABC and ordered 3 and received 5 of product #1-ABE, both on same order) I want the customer to be able to provide their contact…
-
Hiding form drop downs based on prior submissions
I'm trying to mimic a Qualtrics survey capability that enables the survey (form) to only show available dates that have not already been selected by prior survey respondents. Is there a way to accomplish this?