-
Email Addresses with .net
Hi Team, When adding email addresses to contact list, I am receiving 'Please enter a valid email address' for any that end with .net.au Does Smartsheet not support this extension? Thanks, Mark
-
Project budgeting
Hi I'm maintaining a project budget sheet but i am having a problem with a formula i have applied same formula to all columns but last column is not being linked to the total formula bar. I am using the formula =sum(children()) for all columns, can you assist me in figuring this out
-
Row to Form Creation
Hi all, I'm trying to set up our production planning schedule on Smartsheet. It looks like it is going to work well however I've got to an impasse... My standard sheet has 15 columns with information necessary for every job. Every row is a different job. What I need to be able to do is highlight a row, then print this row…
-
Reporting Roll Up
Reporting newbie and need guidance. I have a standard sheet which has an Activity column where the drop down list is Active, Closed, Inactive, Requested, etc.) Each item in the row is tied to a dollar figure. Can Reports pull both columns, but roll up the Activity column by name into a total dollar figure? i.e. 2 rows…
-
Counting a value that appears within a row
I am building an inventory sheet for a nonprofit board and identified a number of criteria the board governance committee will need to track. I've created various demographic columns such as age, ethnicity, residence, etc. The formula below has worked for all the columns created so far but getting "unparseable" error. I've…
-
Sorting Issues
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
Pending Report - Formula Assistance Needed
Y'all... I struggle with formulas. Please help! On our sales tracking sheet, we track probability of the sale closing, expected close date, and the price low and price high of each potential sale. I'm currently using a modified version of the Sales Pipelne with Summary template. In addition to the summary (that shows…
-
Resource Views - limit reports to a specific workspace
Hi - In "Resource Views", is there a way to create a view which limits (or filters) the allocation information to just coming from one workspace? I don't want it to pull data from my "sheets" folder or see data coming from "other sheets". I had some copies in my sheets folder and those got pulled into the view ...
-
Building Sheet to Alert Past Due Items
Hi All, I am trying to build a sheet that will track when items are turned in to our billing department. If the "turned in"date is past a certain date then I would like for the sheet to send a notification to certain people. The only thing is the "turned in" cell will remain blank until the date it is actually received. Is…
-
Collaborators (Editors) Can't See Filter Choices
Hi Everyone, I have created a sheet that is very large. I have also created filters so that each person can find the information on the sheet that pertains to them. I have clicked the button to share the filters as well. However, some of my collaborators don't even see the window with the drop-down box to choose a filter.…