-
Adding Checkboxes
I am trying to created check point progress with check boxes and a visual aid. I created a If formula, but my progress is not adding up. I would like to know if anyone can help me with a better formula.
-
Google Calendar
Hello! I am new to smartsheet...learning as I go. I have published my sheet to my calendar, and I have overlayed my calendar to my sheet, however my appointments on my google calendar that is NOT sheet related (ie. speaking engagements, meetings and conferences) is not overlayed onto my smartsheet. My sheet is utilized as…
-
Interaction with Microsoft Sharepoint
Long story, short as I can make it. I started to create a list of links in Microsoft Sharepoint until I discovered that it seems to be woefully short with sorting, making child entries, etc. In Smartsheet, I am able to accomplish what I am trying to do with ease. Here's my question. Can Smartsheet and Sharepoint interact…
-
Cannot embed Data Studio Report on dashboard
I trying to add a Google Data Studio report to a Smartsheet dashboard using the Web Content widget. The explanatory text says that it can be done, but the link is not recognised as being valid. How can I achieve the desired result?
-
Transfer Sheet and Report Ownership While Keeping in Same Folders
An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and licensed user on Enterprise account.
-
Count days between start and end date
I want to show count of days between start date and end date
-
Contact List [Assign To] and auto-populating this field
In a Project Template Smartsheet, I would like to auto-assign a value to the " Assigned To" column when form data is uploaded. The "Assign To" column is a Contact List type. I would like the "Assigned To" column to auto-select a value in the Contact List based on the form OR another column in my Project Smartsheet. Is this…
-
Report that looks at more two or more criteria but the criteria do not all have start dates
Hi. I'm trying to build a report that will tell me when we are close to sending bills for a district to the print shop. The criteria is looking at two rows with different names in the Primary Column; i.e. Request Information and Original Proof Signoff but I need different criteria for each when it comes to dates. For…
-
How to obtain access to WorkSheet Home without following 3-leg OAuth process
Hi. We are using SmartSheet to store multiple sheets that should be created by one person. This person will share one or more sheets in each of multiple workspaces. I am writing an application (in C#, hosted on AWS Lambda) that must access each Workspace, and Sheet, and read each Sheet. I am using the official SmartSheet…
-
Metric Sheet -Showing Trending
I set up a metric sheet that with CountIfs formulas to show Monthly Stats.. I just realized that when I change the reporting period on my source sheet , I will lose the value counted in the previous reporting period... Is there a way to lock the data values in the previous reporting periods... arggh
