-
IF Function help
I am attempting to use a nested IF statement that assigns a number based on a dropdown selection. Example: User chooses "Medium" in the Impact column, and I'd like to assign a value to that selection in the next column. =IF([Care Training Impact]1 = High, "60", IF([Care Training Impact]1 = Medium, "35", "2")) I receive an…
-
Only perform calculation if cell is not blank
I currently have a sheet and one of the functions I want is to check a box if the Date Won/Lost is older than 365 days. My current formula is: =IF([Date Final (Won/Lost)]@row < TODAY(-365), 1, 0) However, when the Date Won/Lost cell is blank (because the contract hasn't closed or been abandoned yet), the formula returns a…
-
Import Excel file and include embedded images
Hi, I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something? Or do I have to re-import those images manually, one-by-one? Thanks in advance.
-
HTTP/1.1 403 Forbidden
Team, I am using the Sample code provided with the SDK and it works on my desktop (Windows 10 - JDK 1.8.x). The same code deployed on my Linux server - JDK 1.8 fails with the following error What is the cause of this error when it works fine on my desktop? { request:{ command:'GET https://api.smartsheet.com/2.0/sheets', },…
-
RYG Formula Average
Is there a way to take the average of the RYG colors and roll it up to an overall summary for a section and then the overall section to the overall project summary? I've included a snapshot of what I'm talking about.
-
NETWORKDAYS using two different sets of holidays.
Hi, Just wondering if its possible to use the NETWORKDAYS formula using two different sets of holidays, based on whether testing site is Munich or Sydney. I have the holiday dates listed in separate columns e.g =IF([Testing Site]10="Munich", NETWORKDAYS(start_date,end_date,munichHol1:munichHol13), IF([Testing…
-
Sending UPDATE REQUEST to External Emails
UPDATE REQUEST to EXTERNAL Emails Problem statement: We tried to send thousands of "Update Requests" to external email addresses using one Smartsheet as the source so that responses can be collated centrally. This is to avoid sending an email to each external email or sending a blanket BCC email to the same addresses. None…
-
Automation
Do the automation 'rules' stop once one of them has been actioned? I have a sheet which emails employees whose certification has expired. Some of them have two or more expired documents, but my automation seems to only send the first email. (Hopefully that makes sense when you see my screenshot!)
-
Project Rollup Metrics (sum of all project durations)
I have a master sheet that rolls up metrics from my projects for reporting on various KPIs to my leadership. I need to sum duration, but when I link the cell from the sheet it comes over as (ex., 43d). The sum doesn't acknowledge the d, so I am unable to sum the total of all days for a project. Thanks,
-
Workflow Alert Not Working On Hyperlink Updates To a Cell
Hello All I love workflow alerts, they take care of so much emailing I had to do myself before But one variation is not working. Maybe it is just me but if anyone else also experienced same please add here. I have workflow set to alert a number of users when a row changes. This rule works fine for almost every change but…