-
Report filter not working properly
Hi, I'm not sure if there is an inherent filter mechanism as part of Smart Sheet reports but I am trying to use the report filter function to only show rows for specific information. Column 1 - list of products (e.g. apple, orange, grapes .. etc) Column 2 - list of groups that buys the product (e.g. group 1, group 2, group…
-
Novice user, Build Reports
Hi. I have a sheet in which we enter transactions and the date they occur. I would like to generate a report that sums the number of transactions over a certain period. This report could then be emailed or accessed via URL, etc. Is this doable? Thanks!
-
Course seat registration
Hi, I'm trying to set up a form for people to use to register for specific seats in specific courses. For instance, on the form, I should be able to select course A with my name and email . At that time, 1 seat from course A on the sheet should be populated with this data, and the number of available seats should reduce by…
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Logging into Smartsheet
Hello all, We have 3 licensed users, and one of my colleagues set up a free trial it has now expired and he would now like to transfer his sheets to another log in for him but using the same email address. I have tried deleting the account then going in to 'sign-up' but smartsheet seems to remember his email address and…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
IF/OR Formula help
Trying to Auto-fill a value in one column based upon "fixed" drop down list of values from another column. So this is the formula I am starting with. =IF([Product Family]1 = "7765", "252 Industrial", "265 Commercial") I have (3) additional values I want to include that will satisfy the true portion of the formula. How do…
-
Check boxes and formulas
Hello We are using Smartsheets to build ships.. but I have an issue with the formula(S) I want to be able to use a tick box for a formula.. We have many options priced and I want to use the tick box to generate option pricing. If the box is ticked then the price will move to the next column that is auto summed. If its not…
-
Row changes that don't affect Modified Date field
I see in your help documentation that changes to discussions and attachments do not affect the Modified Date type of System Column. Is there a reason for this? If a week-long discussion takes place within the discussion feature of a row, the Modified Date element makes it seem at first glance as if the toipic has not been…
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
