Best Of
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet's helps simplify Project Management for Stakeholders and Sponsors.
Lenny
Re: Happy 10th Anniversary Community + Giveaway!
Connecting all the pieces together to bring communication, data and better organization to your teams!
KBaker
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is a collaborative tool that allows you to share real time information beyond your own internal team while maintaining ultimate control over what you share, how it's shared, and how it can be interacted with by the intended audience.
JMacMillan
Re: Use Javascript in Bridge to efficiently import data from an API
This is the most helpful thread I've come across regarding Bridge! Thank you very much for the tips @Brian_Richardson it still works like a charm : ) I altered the code to be a bit lighter weight since I'm not currently using any custom fields/tags. I will paste below:
const columnMap = new Map();targetColumns.map(column => columnMap.set(column.title, column.id))const rows = []; //Empty array to store cells objects later
for (row of array) {
const resultObject = { cells: [ { "columnId": columnMap.get('User ID'), "value": row.user_id },
{ "columnId": columnMap.get('User'), "value": row.user_name },
{ "columnId": columnMap.get('Project'), "value": row.project_id },
{ "columnId": columnMap.get('Hours Incurred'), "value": row.incurred_hours },
{ "columnId": columnMap.get('Hours Scheduled'), "value": row.scheduled_hours },
],
"toTop": true //need a location value - toBottom or toTop or other
}
rows.push(resultObject)
}
// The chunkArray function splits any array into small arrays of 500 chunks. // This is to allow all Smartsheet API calls to succeed as there is a limit of 500 rows per request.
const chunkArray = (array) => {
const arrays = []; let i,j,temparray,chunk = 500; // Sets the value to 500 items per array.
for (i = 0, j = array.length; i < j; i += chunk) { temparray = array.slice(i, i + chunk); arrays.push(temparray); }
return arrays;
}
return chunkArray(rows)
quinn.flanigan
Re: March Question of the Month - Join the conversation and receive a badge
While I do consider myself organized, I could certainly make some improvements. I've been in my current job for for almost five months and there is always a reset in organizational skills when starting a new job and settling into regular tasks. I'm getting there! This also carries over to personal organization since I am working fully remote - my workspace needs some TLC. :-)
melissalk
Re: Send Dashboard via email - manually and automated workflow
I just spent a significant amount of time creating my Smartsheet Dashboard SPECIFICALLY for this purpose! When will this feature become available?!
Webb_E
Re: File Library: Single File Sharing Now Available!
This is a great new feature since sharing access to the workspace kept us from a few ideas we have had. This lets us revisit those solutions!
Matt Rasmussen
Re: TRYING TO FIND THE ERROR IN THIS FORMULA
You can do a lot of troubleshooting by checking your parenthesis - if you doubleclick into the cell and then use the arrow keys to move back and forth over a ")" it will highlight the corresponding "(".
Looking at your formula, you've got the following issues:
- you have no end to your iferror() function - the format for this function is " iferror(try this, if you get an error do this)" - you don't have anything filled in for what to do if you get an error. Your very last parenthesis should have a comma right before it and something to do in the event of an error, like this (not yet fixed in total):
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN")))), "Error encountered")
2. Next, you've got 3 nested If() statements but your last one doesn't have any instructions on what to do if it is false. If statements are constructed "if(test, instructions if true, instructions if false)" and you've got nothing after "Green" for what to do if false.
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN", "None of them")))), "Error encountered")
3. Similarly, your very first If statement doesn't have a false condition noted either:
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN", "None of Them"))),"Date Blank"),"Error Encountered")
4. Finally, you've got an extra space in your green logical test that is breaking your today() function (and was the cause of the unparseable error you were likely getting:
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY() + 6, "GREEN", "None of Them"))),"Date Blank"),"Error Encountered")
Now it should work for you :)
Jgorsich
Re: TRYING TO FIND THE ERROR IN THIS FORMULA
Hello @Marce Romo
You're missing a value if error.
Your formula should look like this:
=IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF([To Date]@row < TODAY() + 5, "YELLOW", IF([To Date]@row < TODAY () + 6, "GREEN")))), "value if error")
Melissa Yamada