Good morning, I am trying to calculate the number of workdays that an inquiry has been pending since the date submitted. I currently used the following formula =NETWORKDAY([Modified Date/Time]1, [Submitted Date]1) * -1 but then I realized that if an user has not modified the inquiry on daily basis, I will not get a true…
I have to do a monthly membership report for my clients. Right now we use excel. I'm wanting to use smarsheet and have a dashboard that allows graphs and charts. Does anyone have a template that can share or share ideas?
Hi, I'm having challenges exporting from Smartsheet to MS Project on two fronts: 1) Not all the columns are being taken over and I'm receiving the following error message: I've even wiped all the data in the cells to just try and get the column headers to export, but no joy. 2) The data that does export which includes the…
Hallo again, in order to enable my colleagues to work with reports I had to release them also for the sheet yesterday. Actually, I wanted them to use the report in order to fulfil the privacy rules - and because the sheet contains a lot of unneccessary information for them. Is there a solution I can make the data in the…
I am trying to create a chart on a dashboard indicating percent completed. Essentially I have a project where 2 companies need to complete a task for each location. What I have: -A master sheet of all the companies and their locations -A form to enter data -A lookup to the master sheet from the form data indicating if that…
HI Team, In smartsheet can we lock comments in rows so that no can delete comments...it's possible ..please advise ..
Hi Team, Which version of Chrome browser is required for Smartsheet dynamic view..
Hello! Using a Dashboard to run our weekly meetings and had an idea to add in a timer inside the dashboard to stay aware of how much time we have left to discuss each topic. Smartsheet doesn't allow any domain that I know of that can allow me to embed a timer... So I tried a workaround. Embeded a Google Data Studio Report,…
Hallo, (how) is it possible to sum data in reports? There should be a function in the right bar like in the sheet summary - don´t you think so? Hope you can help ☺️
Hi, is there any chance to exclude certain personal data from being listed in the activity log? I would like collaborators to track their time without exposing their personal data at any time. Thank you for all your expertise and help!
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.