-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Rows deleted when deleting columns connected to formatting
Hello smartsheet community, Initially I was tracking completed tasks with a "Done" column which would automatically format the row. After needing to add more options like "Cancelled", "In Progress" etc. I opted to create separate column which contains those options. After clearing all of the "Done" column formatting I went…
-
Export to MS Project (XML) - Greyed out
The function - Export to MS Project (XML) - is no longer working Has it been taken out of my subscription and have to upgrade or someting?
-
Overwriting Lines?!?
Is anybody having issues with people overwriting each other in their shared sheets? We have (3) users utilizing the same sheet and adding in lines at any given time and we started to experience some refreshing issues. It just happened again today as a line I created 2 hours ago was overwritten by another user AFTER they…
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
-
De-Scoping/Deactivating Rows
We need a function where users can de-scope rows, thus deactivating that row and removing its influence on its parent rows. Is that an option via Smartsheet?
-
Date filled in from selecting a checkbox
Community, I want a date to be filled in when I select a checkbox. I came up with the following formula but supplies the current date. I want the date cell to show the date that the checkbox was checked. So for example, if I selected the checkbox on 09/01/19 the date column would display 09/01/19 even though the day I'm…
-
get list of projects worked within last month (without helper fields)
I have a task list that includes what project the task belongs to. The project field is filled in manually (not a preexisting list). I would like to setup a dashboard to show a distinct list of projects that had been worked on, how much time was spent on them, etc. Where I am having trouble is how do I get a distinct list…
-
Transferring ownership of Workspace easily?
Is there a way to transfer ownership of a workspace without having to remove the current owner from the workspace? They still need to own specific sheets, and edit others in the workspace, but do not need to own and administer the workspace anymore.
-
Data Loader Expression Input value
I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…
