-
Cant Delete Sheet that I created
I try deleting the sheet i created in a workspace it shows that it work but then when I refresh the page or log out then it comes back. I tried moving them in to a folder in the workspace and they are not movable. I tried deleting them in 1 by 1 then I noticed some of them has this locked access and It is telling me to…
-
why wont my sheets group properly in my report
I created a report to try and get all my projects tasks organized and identifiable by project. I have the report groups by work breakdown schedule sheet, but for some reason my latest sheet will not break out in its own group. in the image below you can see the sheet that is grouping is the template sheet, but the P-0100…
-
borrar workspaces
hola deje mi cuenta como por 2 meses sin pagar y despues al pagar de nuevo no me deja borrar nada de la informacion que tenia ni revisarla
-
Need a formula that returns a date while factoring in dependencies
I’m looking to add a couple of columns into my project plan sheets. SmartSheet already has a [Start] & a [Finish] column built into its project template, but I’m looking to differentiate between [Plan Start] & [Actual Start] and [Plan Finish] & [Actual Finish]. I renamed [Start] & [Finish] to [Plan Start] & [Plan Finish].…
-
Plan Asset Manager - will it capture orphaned assets already in the system?
Hi, I missed the memo on the addition of the Plan Asset Manager role, and just assigned our admin account this role today. I did some digging because we had a person leave recently who didn't transfer assets before she left, and now we cannot access these sheets/reports. When we deleted her profile, we thought we…
-
Exporting Email Addresses from Smartsheet Contact List for SharePoint Integration
I have a Contact List column in my Smartsheet, but when I export the sheet to Excel, it only displays the full names of the contacts. For my SharePoint migration process, I need to retrieve and export only the email addresses from this column to ensure seamless item creation in the SharePoint list. I'm looking for the best…
-
Creating a formula that takes the total average of a row but excludes certain entries
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
-
Copy of Submission Not Showing All Columns
Does Smartsheet show all columns in the "send me a copy of my response" email from submitting a form? We used to show a critical piece of data in that our submitters would use for their records but now that column no longer appears in that email. The column used to display in the email, and has not been adjusted since the…
-
HELP WITH INDEX/MATCH ACROSS MULTIPLE COLUMNS WITH CRITERIA
Looking for formula help to accomplish the example below:
-
PTO/Absence tracker - how to deal with recurring events
I am creating a PTO/Absence tracker for our service technicians team. I have 2 separate input forms. - one to record/request PTO filled out by the service technicians themselves - another for Supervisors to book a service technician to a client site for a dedicated amount of time, - i.e., every MON for the next 3 weeks -…