-
Revolving due dates
Our Data Team has a form other people in the company can complete to request a report. Often, the report requested must be generated on a regular basis - monthly, quarterly, etc. Within the sheet keeping track of the requests we have columns for Status (of the report), date of request, frequency and Date Needed (the last…
-
Printing Sucks and no collapse/collapse all on the sheets
I know you can export out into PDF, Excel and Google sheets to print, but even when you do the sheet doesn't adjust to shrink to fit, or moving it from 100% to 65%, the sheet is still the same layout regardless of how you try to get it to fit onto one page to print. This has been an ongoing issue with the smartsheets.…
-
Project updates
Hi. I need a way to post project updates (such as weekly meeting key points) on my project tracking documents. This is to keep team members updated on the latest happenings of a project. The obvious solution is to simply create a dedicated row towards the top of a sheet and place the news in a cell. But, because smartsheet…
-
Automating the Date on Forms
I have set up a new form for customer orders with a 'Date in' option however, I would like it to be set to todays date automatically. Is this possible or will we need to fill todays date in each time an entry is submitted? Thank you in advance!
-
When Scanning a Bar Code can it update inventory on the sheet
I wanted to know if there is a way to have inventory get updated either when something is restocked or taken from stock to automatically update the inventory levels when a bar code is scanned or does this need to be done manually? Please assist Thank You
-
Pulling data from different sheet that meets given criteria
Hi-- I am aware that I can select cells X1 - X50, for example, to reflect their sum on a different sheet. But in my case I am looking to automatically calculate sales on a separate sheet. So, out of a given list of prospects, I wish to pull figures only from those entries that have a checkbox associated with a sale in a…
-
Issue with CountIF/AND
Hi all, I am running into an issue with using CountIF and AND. What I am trying to do is count the number of times certain text appears within a 90 day period (based on submission date which is a date column). =COUNTIF(AND({External Range 1}, "Zebra", (TODAY() - {External Range 5} < 90))) I am getting "Invalid argument…
-
Cannot use Outlook Plug-in - Is there alternative (e.g., email address to turn emails into tasks)
Unfortunately my work email address is on-premises Exchange Server so I cannot use the Outlook Plug-in (very disappointing as that would simplify my world tremendously). So far I have not seen an alternative such as a unique email address I can forward emails to auto-add to tasks in smartsheet (such as other productivity…
-
Dashboards (sights)
Hi All, I'm wondering if anyone can help me out. My current client has one program where each staff (4 in total) each individually have their own projects. I created a sheet for them to use that has these columns: Task Name. Start. Finish. % Complete. Status. Assigned To. Done. Risks. Risks & Issues. The staff go into…
-
Issue with CountIFS OR
Hi all, I am running into some trouble iterating on this formula which was a countifs with an "AND." I am now trying to add an "OR" to the first part. I want to see if the Range 1 contains "Zebra" or "Lion" and was entered in the last 90 days. After scanning these communities, I have tried this three different ways and…
