-
How can I run a report that includes the sheet owner as a column next to the sheet name?
I need to send a job list to one of my suppliers. I have multiple project managers working on construction jobs, and they have a sheet for each project. Each sheet can have 3 or 4 tasks for one supplier - such as for plumbing work - and I want to create a report that shows the sheet name (which is the construction…
-
Checkbox N/A % roll up
HI, Was hoping to modify this fomula to ignore N/A cells (in turn, removing the cell from the % rollup) in a checkbox column. =ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0, COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()), 0) * 100, 0) + "%" appreciate it!
-
How to set reminder when activity is not marked complete and current date is greater than finish dat
How to set reminder when activity is not marked complete and current date is greater than finish date for all the tasks in the sheet.
-
Is there a limit on how many update requests I can send?
Currently it seems update requests are not going through properly, it appears to send however my recipients are not receiving the update request. Are there any restrictions on the amount of update requests an individual is able to send? If so is this impacted by whether the user is a paid user or collaborator,…
-
A question about Row Notification
I found some related discussions to my question, but none with specific answers. I want to be notified anytime that someone makes changes to a row on which my name appears in a particular Smartsheet. However, I do not want notifications for entire columns. For example, my name appears in the Assigned To column on row 266.…
-
Adding branding to emails
Hi, We use update email requests a lot and would prefer these to look like they are from our compnay and not from smart sheet. This helps when we are sending these to external people. Is there a way to do this? Thanks
-
Card View - Can I see which subtasks are under a parent task?
In card view is there a way to see which sub tasks are associated under a parent task? For example, say I have a parent task as 'Create Layout' and 3 sub tasks as 'Color,' 'Font,' and 'Images,' is there a way to see how those 3 subtasks are associated with that parent tasks? In another tool I have used the sub tasks are…
-
Calendar sort by date
How can our Training Calendar entries (entered via web forms) auto sort on the smartsheet by date? I used the calendar template and have tried sorting by date, but I am still having to manually move the new entries to the correct row.
-
Sorting a Filter
I am always wanting to sort after I filter, but the option for sorting is greyed out when I have a filter applied. I feel like this is an ordinary function so what am I missing? It must be something incredibly obvious that I'm overlooking. To give an example, I filter the projects to eliminate any status which is…
-
New approach for status on a project plan
our current project plan is driven by organization functions, the item details roll up by function. We want to move towards an outcome based plan, this would be leveraging the same plan but report the status by workstream instead of by function. Each item is tagged with the workstream. smartsheet does a great job rolling…
