-
Searching for the nearest date in another sheet
Hi everyone, I would need a formula where it picks the nearest date in the past related to today's date in another sheet. To give more context, the other sheet always shows Mondays as dates. I tried Index and array but it seems not to work. Would appreciate a template. "Today's Date" cell is based on a formula, I inserted…
-
Summing on filtered columns - Dashboards using same sheet, but filtered
I have a main sheet that calculates all projects in green status and count projects by person. I have dashboards that feed off of this that require the main report be filtered for the other dashboards. How can the fields be calculated off of the filtered fields? I've seen SmartSheet promising an enhancement since 2017 on…
-
Gantt Chart smarts
Hello Brains trust, I have added a checkbox column "Not Applicable to this Plan" to a template project plan. I want the task to stay in the list so that there is a clear indication that this task was considered and then a decision made that it was not relevant. But I want the task ignored in terms of % progress etc. When I…
-
Auto Populate Form Field Based on Form Field Entry
Hello Smartsheet Wizards, Is there a way for a form field to auto populate based on a different form field entry? For example, our contracts have different authorized signatories (Field 3) based on the type of contract (Field 1) and value of the contract (Field 2). I would like Field 3 to auto populate based on what is…
-
Smartsheet Not Working Properly
Hi, Since yesterday in the afternoon, we've been having some issues with two things: 1- Comments are not working when you try to edit them from the search section. When you actually click into the sheet, it works. 2- Some of the people in the office are receiving their email notifications italicized. What can be done to…
-
Link a column to another sheet?
Hi, If you set up one cell to link to another sheet. Can you make the whole column link to that column, or do I have to use a formula? I ask because I'm struggling with formulas and the xlookup I use in Excel is not uploading correctly due to how the workbook is set up in excel. Thank you Kim
-
What tools are available within Smartsheet to managed file storage?
We have an enterprise account and have around 500gb of storage. Across our site we have hundreds of users, and multiple interlinked systems, files, videos etc. We are eating into our file storage, but have no way of identifying which workspaces are using all the space up as you cannot see how much each of these takes up on…
-
Formula to count days a row stays in a certain status?
For a contract management sheet, we are using a drop down single-select to choose the contracts status, ie. new request, attorney review, awaiting signature... I want to measure the average time any row stays in a certain status. The idea is that we can track how many days on average attorney review takes, or how many days…
-
Workflow Manager not opening on a specific sheet.
Hello, I am on day 3 of not being able to access the Workflow Manager on our most used sheet. This specific sheet is the only one that is giving me this issue when trying to open the Workflow Manager and we need to make some changes as soon as possible. Does anyone know what may be causing this? I have contacted Smartsheet…
-
Will moving sheets to a new workspace risk breaking connections, cross sheet formulas, reports, etc?
Just a quick check before I potentially ruin months of work: I built a robust tool, complete with dozens of cross-sheet formulas, Data Shuttle workflows, reports, metrics sheets, dashboards, you name it. If I move them all together to a new workspace, will I break anything? I understand the permissions will change. Just…
