Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Imported sheet formulas not all working
I imported my sales tracking sheet and most of the formulas are working but some of them are not. this is what they say: #UNPARSEABLE#BLOCKED#BLOCKED Here is a screenshot of what I have in some cells. https://screencast.com/t/J1Rvx4iz0 I don't know how to fix this.
Web Forms and entering data via android smartsheet app
I have built my sheet and built the web form. I have downloaded the smartsheet app onto my android tablet. I sen the email link and accepted as the user that i want to have access to the web form. How do I now see and use the web form when in the smartsheet app? It doesnt appear as an option in my list of available items…
Summary table - parsing a table of variable qty of records
Hi, I have a sheet which is an action tracker Actions are adding to the sheet as added rows. I am willing to make some stats andI have to parse the full sheet from top to bottom using countifs functions and alike. PB: my sheet is constantly increasing in length, hence my countifs formula does not parse the full sheet…
Sight in a SIght
Hi, I have built a sight which is a kind of high level summary. In which I have linkwidget to open detailed sights I published the link to the high level sight, and people have it on their mobile / laptops pb: using the link to the summary sight works ok and the summary opens in 'view' mode, but when clicking the link for…
Active Sheet Format Updating from Template
All, My org manages product delivery lifecycles. We currently copy a process checklist template (sheet) for each new product delivery. This checklist also captures dates and data points. Idealy there would be a way to actively update format of the checlist template sheet (additional rows added as we fine tune the process)…
Summary Cell on a sheet that auto-adds form entries to the top row
I have end users submitting forms and the entries are automatically added to the top row. I don't want managers to have to do any sort of parent/child indentation work after forms are submitted, so I've added a column where I have calculated the max value of a very important column and just copied that value all the way…
Parent Sum Children Duration
Is there a way to sum the duration of children rows? Parent row - 20 days duration Child - 5 days duration Child - 10 days duration Child - 15 days duration
New conditional notifications request
I like the new conditional notifications. I especially like keying on deleted rows and being able to disable them. Nice touches. It appears the 6 types of Notifcations are separate entities and that one instance can not be changed or cloned to another. Is this correct or did I miss something? If I am correct, then I will…
Formula IF Due date help!
Hi, I'm trying to do the below: - When a date range - TODAY () is less than 30 it shows 'Current,' - When a date range - TODAY () is less than 60 it shows '30' - When a date range - TODAY () is less than 90 it shows '60' - When a date range - TODAY () is less than 90 it shows '90' I can get it to say current, and it works…
Visualise Planned v Actual Effort
Hi. I was originally using RAG balls to denote if a development task would be delivered on or within the estimated time (display green ball) or if late (display red ball). * We use Initial estimate column to estimate the dev in days * We use an Actual Hours logged column (cumulative) for the developer to log their Actual…
