-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
Adding a Hyperlink to a Web Form
Hi All I'm wondering if there is a way to insert a hyperlink as a default value either into a column or a web form so the user than click the link but doesn't have to create the link in every row populated by the web form. I see a hyperlink can be added directly to a sheet, but my users aren't happy with that. They're…
-
Formula needed
Happy Thursday, all! I have a sheet with invoice dollar amounts in several cells.('Amount') Next to these cells, I have a checkbox column called 'Paid' that is checked on if the invoice was paid, checked off if the invoice was not paid. I need to total all invoice amount cells for invoices that are paid. Any tips on the…
-
Opening emails attached to smartsheet from Iphone
When I attempt to open an email that is attached to smartsheet with the Iphone app I only get a screen that has the file name and size. They open fine from the computer?
-
Conditions of filtered view
It would be very useful to be able to have variable conditions for filtered views. So when defining what you want to view, each criterion has the option of being a "must meet" condition or "desired" rather than all criteria being one or the other. Like a and/or option per criterion.
-
Multiple calendar dates in single row
I have a production schedule that list the issue in the primary column and then column headings with due dates for several items throughout the production process. I'd like to show all dates in each column individually and not with a start/end date. I lose the detail in the middle. Possible? thanks Donna
-
Cannot delete more than 5 Columns at a time
why cant I delete more than 5 Columns at a time? seems rather a silly restriction to have in-place?
-
Event Registration with Form & Summary
I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next…
-
Different columns with the same name ?
How can i make several columns with one same name???
-
Custom Template
Hello, I'm looking for a SmartSheet expert to build out a custom Project & People KPI report template, I know what I want to the end result to looks like but I would rather work with someone that I can share my vision and they can use their expertise to make it happen. Let me know if you would like to have a conversation…