-
Expliciting a sheet name with Strings
Hi all, I would like to calculate the sum of elements in a column (say the 3rd columne) on another sheet. The sheetname is in a column "NameSheet" The following SUM("{" + NameSheet[1] + " Range 3}") does not return anything. I know Excel has something like Indirect() and it would be SUM(INDIRECT("{" + NameSheet[1] + "…
-
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…
-
Objective alignement matrix
hi, i want to create a matrix with all the objectives of the different divisions to see if they are aligned or not to multiple strat plan objectives. Should I have a seperate sheet of objectives for each division or have them all on the same sheet? Do I make a report to compare them? How can I do this ? i am lost in the…
-
Problems with Smartsheet Notifications Email
Hi, i have problems with Smartsheet Notifications email (smart tag). At the moment in which an email notification is sent, configured from the Alerts and Actions section with smart tags. The configuration is as follows: assigned area, text, Request Title; But what is coming to the mail trays is: assigned area, text,…
-
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!
-
Viewing Update Requests and Alerts
Is there any functionality in SmartSheet that will let me (the SmartSheet Owner) see what an Update Request or an Alert actually looks like to the end users. I understand I could send a TEST out to myself and see the Update Request as is happens but I make changes to these standard request often and it would be nice to…
-
Help with SUM function with Duration of Time
Hello all, I have been reading through the forum this morning on how to work around time duration in SS. I used the trusty Travis/Ajayi "formula from hell" to get an actual calculation! yeah!!! My problem is.... trying to SUM the duration column. I have attached a screenshot. I usually use excel... and am not find SS very…
-
Viewing Dropbox attached files
We have an external group of grant committee members viewing a Smartsheet that we are hosting. Some of them do not have Dropbox. If we attach files from Dropbox, are they going to have difficulty opening them?
-
% Complete staying 0
Good Afternoon, I am new to Smartsheet, and am having trouble with what seems to be a simple task. The parent % complete will not change from 0%, no matter what I put in the child's information. Thanks.
-
HELP! RYB Color Change Based on Dates
Hello everyone, I am currently using this: =IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red")))) Which is working but I try to add this: IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" And it doesn't work, I'm…