-
Preview all files and attachments: Excel, word, etc
Idea - Opening a preview of an Excel file (similar to the current PDF previews) when it is an attachment on a row in my Smartsheet. Example from my work - I really would appreciate the ability to preview Excel sheets so we can tell if the document submitted is our new Fiscal Year 24 form or the "old" fiscal year forms that…
-
Team Schedule from a form submisson
Hello, I would like to create a form submission for our team of ~45 to input requests for shift times, and days off requests. I want it to encompass the entire month, with the option to select multiple shift times for each day, and multiple days in a week - We currently use an excel doc which looks like this
-
Copy/Paste Columns with Drop Down Lists in the Same Sheet
I have a large sheet with dozens of columns, each intended to have cell drop-down selections (team member assignments) with 20 choices in the drop-down menu for each cell. There does not seem to be any way to copy/paste the column with the drop-down menus within the SAME sheet (not to another sheet). Therefore, the only…
-
Alerts with smartsheet form link is not running
Hi Everyone, I created a sheet to capture the inputs coming from forms. I set an alert workflow to send automated mailer with form link to designated SPOCs. But the alert mailers are not being sent. There is no issue with domain whitelisting as other update requests and mailers are running successfully. Alert workflow is…
-
Latest Comment column disconnected, still not able to create new or recreate
I followed the process in the post "Can't select Latest Comment in the edit column properties", disconnected the Latest Comment, Saved/Refreshed, renamed original Latest Comment column, refreshed again, then Inserted Latest Comment (via comment ellipses). It created the Latest Column column but it's not marking it as…
-
Rename Levels
I'm reviewing this discussion but have a question related; What I am trying to achieve is to create Alias's for the following; When level is 1 call it "Header" Where level is lowest level number child call it "Task" Ignore everything else, for example; first child is still a header but its not an important header of the…
-
Counting Entries Satisfying a Condition and Within a Certain Month/Year
Hello Everyone! I am trying to create a formula that counts the number of times a condition is satisfied for each month/year. My sheet has a column "Parameter" that either has the value "OFF" or "ON". I would like to create a formula that counts the number of times "OFF" occurs per month. However, the dates in my data…
-
Remove Formatting from Reports
When entering a Report into a dashboard you have the ability to remove formatting. This same feature would be great to have in the report itself.
-
A resource left the business. How do we keep a track of his hours?
We've just done a reconciliation as part of an audit. We got dinged by the audit company because the hours in Resource Management don't match with the hours we billed to several clients. This took some investigation but we eventually realised that the system was not counting any of the hours logged by a Project Manager who…
-
Moved: Is it possible to copy a workflow in the jira+smartsheet connector?
This discussion has been moved.
