-
User Friendly Search
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
-
Merged: Add Grouping to Report Exports
This discussion has been merged.
-
HELP! Move Row Automation
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
-
Automated Workflow Setup to Notify Users of Completion Not Working
I setup an automated workflow to notify users via notification email once their requests have been fulfilled. I've configured the workflow to trigger a completed notification email to the requestor based on the email in the Requester Email Address column after I've changed the status to Complete in the Request Status…
-
Hyperlinks
Hello all, I need help i have a sheet that every week i add about 300-700 lines and each one of them have a Different link, is there a faster or easy way to add them all together? and not each line at a time ? I don't mind adding them all as "LINK" but for now as i am adding them one at a time i am adding Them to the…
-
Merged: If Status is Complete - End Date is Updated to Today's Date - With Dependencies/Predecessors
This discussion has been merged.
-
Looking for Tips on Building Smartsheet Buy-In
Hi everyone, Our department is still relatively new to Smartsheet, and overall, the rollout has gone well — most team members have been enthusiastic and quick to get on board. We’ve also had a few internal champions who’ve helped drive early adoption, which has been a big help. That said, we’re seeing a bit of hesitation…
-
Data Entry Suggestions for Siloing Data for Radar Chart
Hey everyone, I’m exploring the best way to use Smartsheet for collecting score card data and formatting it for a Radar Chart. Ideally, I’d like to: Enter audit results in Smartsheet Modify or structure the data in another sheet Format the combined data for visualization The goal is to merge audit percentages from the…
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.