-
Using formula to copy row to new sheet as a child row
We have created web forms to retrieve new client information and new project information. Both forms contain the Primary Column "Client Name". I know we can link cells from one sheet to another. But what I'd like to know is if we can set a formula (or link a sheet) so that when a new form is submitted (and it is added to…
-
Anybody else having trouble with reports this morning? Did checkbox behavior change?
I have reports for each team member and the tasks they are assigned. The reports are now missing the majority of the tasks assigned to that person. (Not all). I have checked the source data and the report filter criteria. Nothing has changed. I cannot get any previously created tasks to show in their reports. The only way…
-
How do I export the names/emails of collaborators who have access to a Workspace?
How do I export the names/emails of collaborators who have access to a Workspace? I need to send an MS outlook email to all collaborators of an existing workspace (over 70 ppl). In an effort to save time (e.g. avoid typing names 1:1) & heartache (e.g. inadvertantly leaving off a person), is there a way to export…
-
Can I eliminate everything from a cell except for the end?
I would like to create a new column that will essentially copy over information from a different column but will only take the last few digits. For example, the first column will say "John's Business 290583958". The last digits would be the Sheet ID of "John's Business". In the second column, I would copy over the…
-
Desktop install of Outlook 2016
I have Microsoft Office 2016 - a desktop version installed on my Surface 4 Pro. I attempted to download the Smartsheet Plugin and it opened what appears to be another version of Outlook, one that may be available with the Windows 10 or something online. Is there a way to set this up directly to the desktop version??
-
Report Builder - sheet won't pull if cell format is drop-down
I've built a report with criteria to pull Category field if it contains 'security'. If I format this field as a drop-down, the report won't pull the sheet. If I switch to Text format for the field, the sheet pulls into the report.
-
Is multiple baselines supported in SmartSheet?
Hi, I would like to know whether SmartSheet supports multiple baselines. Generally, I use MPP for project planning, wherein i have "Baseline1 Start", "Baseline1 Fisnish", "Baseline Start", "Baseline Fisnish", "Actual Start", "Actual Finish" in my Tracking Gantt. When i prepare a project plan and have the same reviewed and…
-
Printing parameters
Is there a way to change the font size/etc in the reports and for printing purposes? I have a CAD printer and would love to have the option to print on just one continuous page....and to level all the fonts within the report that i am printing. More options please........
-
Access contacts from contact list in one sheet to share another sheet to
How to access contacts from a contact list in one sheet to share another sheet to, or send request updates to?
-
Using API to merge an attachment from Smartsheets into a Google Doc?
Has anyone used the API to merge the attachments in a row into a Google Doc along with the information in the row? I have used the merge and created a template which merged the info in my rows into a beautiful form and emailed it for me, but I also need to pull out the attachments that are included in that row and send…
