-
Project Resource View
Hi Friends, In 'project resource view' currently I can see all members (project assigned members). But I don't want visulaize all members capacity at once. Is there any filter option? Reason: One month back my team member moved to other team & I am not assigning any task, yet I see him/her in the 'project resource view'.
-
Tracking a date change
I am new to Smartsheet in a company with limited knowledge about the features. We use a combination of sheets and a web form for 'ad-hoc' requests that are managed in a queue. In the queue, there is a "Due Date" column. This date can change over time and the manager for the area would love to be able to track that change…
-
Currency converter
Hi, I have project expenses in different currencies (EUR, GBP, CHF, AUD) and need to convert them all in USD. Is there a solution how I could enter fix exchange rates and after entering e.g. EUR 100.- to get it automatically in new cell / row converted in USD 112.-? I have added the example
-
removing check boxes from a row
Hi all - this seems like it would be easy but I cant figure it out. I have a spreadsheet with different sections, most rows I DO want the check boxes but on my header rows which are separateing my sectinos I DO NOT want the check boxes but I can't figure out how to get rid of them since they are a column property. Anyone…
-
Parent Row Column Properties
Hi there Team, Is there a way to 'remove' or not apply the Column Properties to a Parent Row. I have a number of Sheets that have Checkbox - and CF based on the value - but only applicible to Children. Purely (for me anyway) for ease of looking over an entire sheet, is it possible to not apply the Column Type to a Parent…
-
Feature request: Enter formula in report
I know that Smartsheet does not currently support creating formulas from a report. Any formula manually entered in will display as plain text rather than performing a calculation. I am not sure how the would work, but it would be nice to have a way to enter a formula into a report and have it calculate. I envision this as…
-
numbers that start with zero and webforms
I have a webform that I am trying to create but one of the columns is a number field where the number commonly starts with a 0. My problem is that when you submit a number that starts with a 0, the 0 gets dropped unless the field is formatted as text. In smartsheet, the only way I see to format a field as text is to add an…
-
Using Report builder to find past due 'Days' tasks
I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open' and 30 days old. I can check for 'Open'. But I wasn't able to find a way to check for 30 days old in the report builder. Can I do this just using the report…
-
feature
Hello - I would like to keep the start and end date of a project. Without having an attachemnt associated with the project, can I add people and their roles for this project, on the lines below the project, and then hide those lines? Thx.
-
Please Help
Hi, Smartsheet friends. I am new to Smartsheet and am still trying to find my way around. Is it possible to calculate a formula on one sheet that references data on a separate sheet, like you can in Excel? I have a master sheet that includes all my data. I tried to summarize the data using various calculations at the…