Smartsheet community, I have tried smartsheet labs for the charts and have a live iframe to be embedded in the Dashboard but there is a no widget to include iframes. can we include this and do we have better options for charts and dashboards in smartsheets as i feel still a long way to go for better dashboards in…
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the week into a running yearly total. On my spreadsheet I have a Total YTD Hours Column, A column for each day of the week that…
I am trying to auto populate a column based on a selection I make in another column.
I'm using the Event Registration template for people to sign up for a webinar and I'd like to send registrants a link to the webinar after they register. The only way it works is if I include the option to send a confirmation. BUT, the person registering has to click that box and I can't make it a required checkbox. I know…
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
Hi guys, I'm new to smartsheet and I'm trying to figure out it can help me become more productive. So far, I have always used excel. I am working with a lot of minute by minute schedules tailored to the needs of the different departments in my company. I have one large file displaying all the small activities that happen…
I am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Data Type error. =COUNTIFS({Sheet1 Range 3}, AND(@cell <= TODAY(), @cell > TODAY(-30),…
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
I'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6) Yeah, I am an extreme rookie when it comes to this stuff.
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…