-
Displaying an overall completion % within a dashboard
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
-
I have lost access to my sheets after a license change. How do I get edit capabilities back?
I have recently moved from a business license to an enterprise license, and now all of my sheets I created are set to view only. I have validated that I am a Member under the new enterprise license, I am owner of the sheets, and I am in the correct region that my sheets are in. However my sheets are still view only. How do…
-
Conversation and Attachment Indicator at the Sheet Level
Color code or indicate when there is content in Conversations and/or Attachments (Icons) at the Sheet Level. This would eliminate clicking on the icon to see if there is content to view. See attached for an example.
-
Customizable Banner Messaging to Subscribers
It would be great if we could customize the banner displayed within sheets as done by Smartsheet to market new features so that SysAdmins could message to their users without the need to do by emails. Examples: Renewal survey is about to launch, Did you know you can go to our company resource dashboard by doing xxxx,…
-
Formula Cell Reference Limit (25,000,000) Not Refreshing
Hi all, We're having an issue where the 25,000,000 formula cell reference limit was reached after adding a new column, but even after deleting way more columns and cell references than we added, it's still showing the attached error message and not letting us move any new rows into the sheet. We should be far below the…
-
What is the maximum number of rows that can be added to a sheet?
I've searched for 'Row Limitations' on the help center, and haven't found an article which explains clearly so asking here. What is the maximum row limit (vertical, up to down) on a single sheet? I've seen both 5000, and 20000. Additionally, is there an article where this information is contained?
-
Can you have a column showing a driving predecessor for a task?
In my job as a scheduler a common question is "which of the predecessors for this activity is driving the date?" Currently I have to rely on my own knowledge of my schedules or, worst case, I have to look at every predecessor until I find the one I am looking for. Microsoft Project is nice because it has the "inspect"…
-
Linking Auto# Columns
I have 2 sheets that I need to link: Sheet 1 - collects user registration information through a form. Sheet 2 - I want to link some columns to copy partial data collected in sheet 1 and have it show in sheet 2. I don't want to copy the entire row, just select columns and I don't have Smartsheet Bridge. Each sheet has a…
-
Merged: Sheet Flag for Comments, Attachments, etc.
This discussion has been merged.
-
Average by section within a column
I am working on a sheet where we are tracking the percent complete within a column. The top percent complete formula is =AVG([Percent Complete]2, [Percent Complete]17). The formula in [Percent Complete]2 is =IF(Completed@row = "Completed", "100%", COUNTIF(Completed3:Completed16, "Completed") / 14) The purpose of the…