-
Sheet limit within Smartsheet
Hi everyone, I'm about to embark on a large scale server back up and am hoping to keep all of my data logs on Smartsheet for safety. There will obviously be a massive amount of sheets to hold and I was just wondering if anyone knew the limit on how many sheets you can host? I'm a licensed user and am part of a team…
-
All my text, most of my predecessors and all my resource allocations - disappeared
I have been working on a Smartsheet for my client - I am a licensed user on their system. I had just tidied up all my reports and old sheets…. and disaster! I can see the structure of my plan, but it has lost all the text, predecessors and resource allocations! This is most strange - see attached screenshot. I cannot…
-
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…
-
Looking for a way to associate a checkbox in one field with content in another.
I am creating a log of all new, won opportunities. The goal is to catalog the types of services included in each new opportunity. Next, we need to understand the revenue split by service types. I created a web form that allows users to "check" the service types in the opportunity. Next, I need them to allocate the revenue…
-
Alert notification for when column goes from blank to...not blank?
Hi all, Looking for a way to receive a notification for the first instance in which a cell goes from blank to filled. We need the date on which a designer is assigned for any given "GRS" project - but that designer may change over time. We are only concerned about the FIRST update. Any ideas on how to set up this kind of…
-
Event registration with limits on attendees
I need to create a registation form (no problem) that will include total number people attending (no problem). How do i stop registration when the capacity is reached? Thanks. Ken
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
Date in a CountIf formua
I want a calculation that displays a summary of how many records have a complete date greater than or equal to 1/1/2017. Here is what I add to the cell: ="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1/1/2017) Then I get an "Invalid Operation" messag and SS adds spaces to the date portion of…
-
New tasks added Saved but then lost
Has anyone had the situation where you have added tasks to a plan, Saved, and then come back later to find that the new tasks are not on the plan? I manage several projects and this has been happening for a couple of days now on one of my projects.
-
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)…
