-
Release Milestones
I'd like to establish a row that holds our release schedule. Every three weeks I'd like some visual marker that indicates that we've got a new release. That seems possible in Smartsheets, but establishing a cadence of milestones seems to require individual rows for each release. Is there a way to place markers without…
-
Average the number of days
I am trying to work out the average number of days quotes are being taken to be submitted. The columns i am working with are Enquiry Date and Date Quote Submitted. I have done a Sum formula to count the number of days taken (=SUM[Date Quote Submitted]1 - Enquiry Date]1 but because not every enquiry has a date submitted…
-
VLookup reference another sheet
Hi I am trying to do vlookups that reference another sheet. The main sheet has 13,000 cells, but when I create the link, it says its been denied as the limit is 25,000. I should still have 12,000 cells free. Does anyone know what is happening here? Thank you
-
Indent Greyed Out
Hello, I am unable to use the indent feature. I followed all of the instructions in the tutorials as well as looked up in the community other issues and followed those instructions but the indent option is still greyed out.
-
Remove User from Enterprise Level
Good morning, In the Team level, I had access to a report that showed me all Users per sheet/report, so that when someone left/changed departments, I could easily see what access they had. This report is no longer available to me since we went to the Enterprise level, and our SysAdmin says that the report only shows them…
-
Project Team Widget
I want to make a dashboard widget for my project that shows a report containing all individuals that were assigned a task in said project. I know that the "assigned to" column can be pulled in a report, however it shows multiple instances of each person because each person does multiple tasks in each project. Is there…
-
Smartsheet Notification
When we are in actual Smartsheet making changes, as an example: Row 226 - we added and saved comments. However when a collaborator received the notification of what changes were made, the Row 226 becomes Row 474 which would be incorrect and would require additional steps to look for Row 226. How do we fix that please?…
-
Dashboard View
Good Afternoon, I'm interested to see if the capability exists to change the orientation of dashboards. This may be basic, but it seems that portrait orientation is about all you get unless you limit the amount of information and customize the orientation in the print function. Does anyone know of any other way? Thanks a…
-
Forms: Text box inserts based on select answers
Hello community, I am using a form as a survey and am trying to use a "If yes, please explain what/why" option. Is there a way to pose a question on a form with a Yes/No answer and can select based on which of those answers will add an additional text box to another column or so? Appreciate any input or ideas people may…
-
=if function with networkdays
I am attempting to write a formula where I can look at a date field and if it is blank have the formula calculate networkdays between two fields and if the date field is not blank then calculate the networkdays between a different two fields. I have this as my formula: =if([Order Approval Date]2 ="",NETWORKDAYS([OAM…
