-
Formula
Hello everyone, I'm new to smartsheets and so far my experience has been positive but I'm heading into areas that go beyond what I have learned so far, I used basic formulas to do counts using =SUM, and =COUNTIF but I only have been able to use it to do basic counts. I need a formula that will look at at multiple columns…
-
Report or view for staff allocations
I'm a Smartsheet newbie. I'm trying to figure out how to pull a report (or a different kind of view) to show staff allocations across different sheets. Any help would be appreciated. Thanks!
-
API Access Token for Single Sheet
Hi, I would like to generate an API Access Token for a single sheet. Currently, if I provide my API Access Token in a script for others to use, they can use it to access all of my sheets (and those shared with me). Please let me know how to do this. Thanks, Brent
-
Holding a calculation until specified date.
Hello, I would like to set up a row of cells to run a calculation at a specified date and time. If that is not tricky enough, I want that calculation to remain as is thereafter even though the data that the calculation uses would change frequently. Is there a way to prevent a cell from running a calculation until a…
-
Make the rich text editor edit report cells on the dashboard
Greetings everyone, I was wondering if using the rich text widget to edit a cell in your report on the dashboard live is possible. The logic behind it is: The rich text editor is linked to the cell from a report and updates data simultaneously. Thus, I wouldn't need to go back and forth to the report and then to the…
-
SUMIF problem - "#incorrect argument set"
Hello, I am getting the "# INCORRECT ARGUMENT SET" error when using the following formula: "=SUMIF({Treads Extruded 2019}, MAX({Week no.}) = [Current wk no.]1, {Production Qty})" I have attached an image of the table I am working with, removed any sensitive information. I want to add all of the production quantity up for…
-
Count "New Entries based on a date" to a dashboard
I am adding new entries to a sheet daily. I need to know on a given date how many entries were added to the sheet. I need to be able to adjust this daily. I have created something on a google doc that works very well but I can't seem to duplicate it in smartsheets. My goal is to have this count reflect on my sheet…
-
Legends on Calendar
Is it was possible to add a color legard on the calendar view? I noticed someone else asked a year ago and wondering if maybe Smartsheet made this possible. See screenshot.
-
Uploading Users / Resources
Aloha, new to Smartsheet set up from scratch. Using free 30 day trial and tried to load users (80), but seems it surpassed the max allowed number. do you guys know how many we can use? Also, please help understand how to avoid sending email notifications even when the upload FAILED. Thanks!
-
Nested Formulas
I am attempting to use the nesting formulas to auto generate text showing the status of a project step that is co-dependent on several previous steps, but only when the previous steps have been selected. For instance,we have an "Assigned" column which is just a check box, a column which indicates if that task is complete…