-
Calculation Sheet for multiple sheets
Hi Guys I have a calculation sheet that is currently bringing in data from 3 external sheets in order to be able to create reports and graphs for dashboards etc My problem is that I am conscious I will reach my cell link limit, along with the fact that 3 or 4 more sheets will soon have to be included in calculations,…
-
Using Generate Documents and naming output file based on row content
Anyone using Generate Documents that has devised a way to name the pdf output file with a unique name? Well, more unique than "[original name] (0)" ? Dale
-
Comments @email to non viewers
Hello. Our sales team feed data to a sheet by form only, they do not have access to the sheet. Out Accounts team with access to the sheet receive the data and at time need clarification on a row entry. We would like this Q&A captured in comments to the row. Is there a way to @email non sheet viewers through comments and…
-
Using Multiple Condition Paths Simultaneously
I would like to set up an automation where depending up a multiple select field there are actions for different groups. i.e. If the field contains 1,2,3 then there are 3 Condition Paths and all of them would trigger, however if the field only contains 1,3 then Condition Path 2 is ignore. However, in my testing, what…
-
REPORT BUILDER REMOVING UNKNOWN SHEETS IF EDITED BY NUMEROUS ADMINS
Reports no longer show "unknown sheet" placeholders that the current user is not shared on If he/she edits the report builder on a Report that includes sheets he is not shared on it will remove those reports. Please bring back the placeholders so that the sheets added to the reports don't get deleted. We have multiple…
-
chart dates VS. Progress
hello, Is there a direct way in the smartsheet to give me the same chart to track progress in a weekly or monthly matter ?? as the client wants to see a weekly report regarding the progress in reference to the date? Thanks,
-
Document Builder not mapping into form fields
Hi folks, Just before Christmas I started playing with the Document Builder to generate our supervisors' monthly reports and it was working a treat, but I've just come back and tried to generate a report and some fields are coming up empty, even when there is text in there. Has anyone experienced this issue and might know…
-
pivot tables are not updating graphs
i have set pivot tables to refresh immediately but they are not auto refreshing when data is added manually to a sheet or via a form. Only way i get them to refresh is to manually go in to each pivot table and refresh
-
How to reconcile the Data
Hello, We have Data in 2 spreadsheets and they need to have concatenated fields and by matching up those concatenated fields, the data should populate in another column, here Vlookup is being used, any tips are appreciated. Thank you
-
Using attachments in proofing functionality
Dear all, It seems like, for people reviewing (and approving or declining) proofs, there is no option to use attachments in the feedback. They can type text, but can't add attachments. If people have edit rights on the sheet and they go to the sheet directly and then to the proofing panel, they can, then the 'paperclip'…
