-
Reports Overwriting data in Sheet
I have a sheet that I use for collating data of time taken on a particular works order. To compete a works order, it requires 3 seperate workstations. However, I have set up 3 seperate reports, linked to the one sheet, for data input. The issue I have is that if two workstations both enter data at the same time, and one…
-
Linking date columns
Hi, I am linking date columns from a master sheet to another sheet. When linked it seems to change the format of the date. For example if the date in the original sheet is 12/08/19 (12th August 2019) in the linked sheet it is displaying as 08/12/19 (8th December 2019). The original cell doesn't have any dependancies.
-
Tracking Time (Tasks)
Greetings, Looking into the prospect of getting my engineers to enter time spent against tasks in addition to 'guessing' and their percentage of completion. It seems the threads here are all a couple years' old or more - wondering if there's any advancements in this arena recently. Regards, jc
-
Using COUNTIF to find the number of Blank Spaces
I'm trying to count how many blank spaces there are in a given column. However, whenever I put in the below formula, it just gives me the total amount of rows in the column, but the entire column is not blank: =COUNTIFS({CDVL Project Tasklist Range 4}, "") I've also tried this formula, but to the same results:…
-
Creating a Link in Dashboard from local drive
I have previously been able to create a link to a local drive document on a dashboard but now don't seem to have the choice. Can someone point me in the right direction please? I have the options of Google Drive; OneDrive; Box; Dropbox; Evernote; Egnyte Thanks
-
Cross-sheet formulas
I love that we're now able to use ranges from other sheets in formulas. I just updated a summary sheet so it uses formulas linked back to worksheets for each member of my team, rather than having the formulas on each team member's sheet and linking from there. I have a couple of questions about the best way to use the new…
-
Recurring Reminders
Hello and thanks for any assistance on this! I'd like the ability to set automatic recurring reminders for my clients. The ability to have a column "Follow Up" with a drop down menu showing 2 weeks, 1 month, 3 months, 6 months,etc... and then have an email sent to me every 2 weeks or whichever was selected. I'm ok with an…
-
delete this post
delete this post
-
Pasting hyperlink cell from Excel no longer working
Until today, we were able to copy a cell from Excel that had a hyperlink, and paste it into a Smartsheet cell and it would maintain the hyperlink. This has stopped working today. It pastes the text, but not the hyperlink, and this is a critical component of our workflow. We use Chrome as our browser and have never had this…
-
Master Schedule
We have a a master sales information sheet that imports from our sales software and then links out to individual client sheets. Each of the the client sheets links to the previous job via cell linking and predecessors, We then have a portal that includes a gantt view of a report that we look at for scheduling - see…
