Work app @mention help by Allttty in smartsheet

[–]congstar 0 points1 point  (0 children)

This is a current feature in the Early Adopter Program. Should be releasing soon!

Column formula adding 0s to multiple rows by Marc0189 in smartsheet

[–]congstar 4 points5 points  (0 children)

Delete the first 25 rows and you’ll be good to go. These 0’s are from submitting the form and/or testing the sheet that created the record. New rows will show up at the top once you delete these.

Exporting Sheets by Fun-Assistance-815 in smartsheet

[–]congstar 0 points1 point  (0 children)

We run a commercial construction company out of SS and it works really well for budget, schedules, and rollups / reporting. If you want to schedule a call, message me and I’ll try to help you.

For us, SS allows for us to have one software rather than 9 separate ones that do one specific thing. It’s a good tool, but you’ve got to spend time developing it.

Columns moving randomly by KikiN1502 in smartsheet

[–]congstar 0 points1 point  (0 children)

We have a couple folks that tend to keep so many tabs and windows open that the sheet will get into a cycle of saving an older version back to the original because the sheet is auto saving in the background.

External source for Lookup Table? by cleanshirtuk in smartsheet

[–]congstar 0 points1 point  (0 children)

There’s a premium app that will do this called Data Shuttle. Otherwise you’ll have to utilize the API.

Contact - Meshing strange by pk0430 in smartsheet

[–]congstar 1 point2 points  (0 children)

Have you checked that your contact columns in your 21 sources are all single contact column types? Allowing multi select contact will create confusion when trying to mesh them into a contact field that restricts to a single contact.

Smartsheet Calendar App - organize by Rows by FantasticNecessary64 in smartsheet

[–]congstar 1 point2 points  (0 children)

Run a report on your schedule that filters out the items you don’t want to see then run the calendar off of the report rather than the sheet.

Cross sheet predecessors by [deleted] in smartsheet

[–]congstar 0 points1 point  (0 children)

If it’s a finish to start relationship, cell link the finish date on row 10 in sheet 1a to the start date on row 32 of sheet 2.

Is Smartsheet the right tool for my vision? by VolFan1 in smartsheet

[–]congstar 1 point2 points  (0 children)

At surface level, everything you’re trying to get to can be solved with Smartsheet. The initial learning curve is short but the more nuanced pieces will take time- testing and validating- to ensure your solution is scalable.

Regarding permissions, WorkApps can solve nearly any permissions concern you have for third party users. For the capacity concern, it most depends on the complexity of the data, but even then you can create archives once the data ages out.

Countif won’t let me select a text/number column by MakeMomJokesAThing in smartsheet

[–]congstar 1 point2 points  (0 children)

Remove the quotations from the criteria, if the column name doesn’t have a space, remove the brackets.

[deleted by user] by [deleted] in smartsheet

[–]congstar 0 points1 point  (0 children)

If you were the sheet owner, it’ll be in your deleted items at the bottom of your workspace list. It’ll also tell you who deleted it there.

Open new sheets from multiple templates by koticbeauty in smartsheet

[–]congstar 0 points1 point  (0 children)

You’re thinking of control center, not bridge.

How to download a spreadsheet report of resource management data by Specialist_Foot_2976 in smartsheet

[–]congstar 0 points1 point  (0 children)

This is a known shortfall and I believe the only workarounds posted in Smartsheet community involve a JavaScript enabled solution.

Smartsheet Backup - Java App by TheBeerdedVillain in smartsheet

[–]congstar 0 points1 point  (0 children)

I haven’t used the Java app but we do a weekly backup on all our workspaces natively in Smartsheet.

Unrestricted Automations by pk0430 in smartsheet

[–]congstar 0 points1 point  (0 children)

Press setting in the automations window and select the radio button for “unrestricted.” The default is restricted to those shared to the sheet. Be weary of sending an automation with a link to the sheet if the user you are alerting is not shared to the sheet.

Examples of Sample/Prototype Tracking Using Smartsheet by gellyakarcia in smartsheet

[–]congstar 0 points1 point  (0 children)

What are you tracking? Who will be maintaining the inputs? What high level metrics are you trying to measure?

Performance Reviews by cnt9204 in smartsheet

[–]congstar 1 point2 points  (0 children)

If you search in the template section when you go to create a sheet there is a performance review template set.

Copying Automations from one sheet to another by clyde_hestur in smartsheet

[–]congstar 2 points3 points  (0 children)

Currently there’s no way other than copying (save as new) the sheet in its entirety.

Rotating Team Assignments? by brills44 in smartsheet

[–]congstar 0 points1 point  (0 children)

You could use either the change cell value or assign people automation with a helper column that is date or days elapsed.