-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Automated Workflow Notifications
Hi everyone, Is anyone having issues with notifications? Since yesterday, I've had a few automated workflows that, when triggered, are not sending the email notification or even alerting the user via the Notification bell.
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Checklist tool in the toolbar on the right
Smartsheet is nice for task management and project management. The challenge is when task management and project management intermingles. That is, a larger task is allocated to one person, but need to be divided into several steps or sub-items. If this is done as spearate rows in smartsheet i creates chaos in the…
-
Track milestones in projects by Completion date(due date) and labor allocation estimated
We have many concurrent flowing projects with the completion date being the only important date for each. Under each project, 5-6 major areas with 50-100 sub-tasks(concurrent mostly). Having to enter dates for each is not useful. Because moving one project, affects every other project worksheet dates. So that could entail…
-
Formula to pull the Fiscal Year from a Launch date
Hello! I'm looking to pull the Fiscal Year in a cell based on the launch date in a different cell. Our FY starts on 04/01 of the current and ends on 03/31 of the following year. I need the formula to determine if the FY is the current year, the prior year, or the next year based on the launch date. For example, 04/25/2024…
-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
Will IF(MAX(Collect work?
Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into our project tracker. The origin sheet is calculating the countdown number based on one particular type of work request and…
-
Projected Labor Needs & Labor Schedule
I have multiple tasks with various durations. At some point, most task's duration overlaps with another. I need to project out on any given day what my total labor needs would be for that day. I have two sheets: Sheet #1 - Labor Schedule Sheet #2 - Projected Labor Needs In the snip-it below (Top Part Clouded) I have…
-
How do I make a direct connection from my sharepoint list to smartsheets?
I am a sharepoint user that exports information into an excel spreadsheet. How do I use that connection to export straight to a smartsheet?
