-
Several Columns Have the Same Name
I have several workspaces that people use to make different sheets. The problem is that whenever I try to make a report for someone and I'm sorting out which columns to include, there are several columns with the same name. For instance, if the column name was 'Contacts', there are four columns named 'Contacts' which each…
-
Searching With "*" Does It Still Work?
Before the recent update we would perform a search using an "*" before our part number so it would find all of the different entries. We have some users entering part numbers like, SO001234 or SO1234 and by searching *1234 we would find both results. Now it appears the * no longer works. Any other option. Thanks
-
Copy Row Automation
I have a workflow which when a new row is added and fulfils a set criteria, the row is copied across to one of two sheets. When it copies across, the row is filled in in its equivalent row in the primary sheet. How can I get the copied rows to fill in the next available row on the new sheet? Here is an example of the row…
-
Several People Assigned to a Task
In our projects, we have many different departments that are assigned to the same task, since they all play a part in that task. The problem is that a lot of departments will finish their portion of the task while we're still waiting on a different department to finish theirs so we can check the task off. This leads to us…
-
There are too many cells referenced by formulas in this sheet
Hi, I get this message "There are too many cells referenced by formulas in this sheet" every time I load a specific sheet. Then the sheet disappears & Chrome leaves this message: Aw, Snap, Error code: Out of Memory Would anyone have an idea how to tackle this ? I'll try to clean Chrome temporary files to get more available…
-
Email address in Form entries
Hi When a user click 'email me copy of responses' in the form submission, is it possible to pull that email address through to the data set somehow? I can't see that I can see that particular field. Thanks
-
Gantt View Weekends
Is there any way when using a gantt chart to get the task bars not to show running through weekends. This is not a major problem but we have had several of our customers who are more used to using MS Project asking us to show our charts in this way. The ideal scenario would be if you have set the sheet to a 5 day working…
-
Workflow Sheet Data Transfer
I am an office coordinator in education and I'm part of a team attempting to schedule volunteer positions for an event. We have a list of positions that need filled, and Smartsheet is going to be great for managing the workflow once they are assigned... However, in Smartsheet forms, I can't find a way to limit each type of…
-
Setup/Formula Advice
I am seeking a way to manage changes for the following situation: A project stakeholder register template leverages Vlookup to a master Employee Roster to facilitate completion of the register (e.g., employee title, Dept. etc.) When the template is used, automation is setup so that when "Copy to Stakeholder Rollup" is…
-
Managing Currencies in Smartsheet
Hi, I have a sheet that shows annual spends for certain vendors. I want to display all those spends with the $ currency sign and then use an =sum formula to add together all the spends to show the total spend in the blue bar of my screenshot. Two questions: How do I add a $ currency sign and commas to my blue annual spend…