-
errors
hello i am trying to use the COUNTIF function, where the range & criterion are the results of a VLOOKUP from another sheet. When the VLOOKUP doesn't find what it is looking for, it returns a #NO MATCH Error and this in turn gives a #NO MATCH error in my COUNTIF. On the VLOOKUP it is looking up an activity against a range…
-
Multiple Individuals to CC when sending a Email.
Currently when you send an email on a certain row you can only CC one individual and that his yourself. Can I have multiple individuals added to this CC? Typically I am sending correspondence to customers and ideally would like to CC individuals in my company that I have sent a specific email. Presently I have to receive…
-
Picture upload - resize
Hi, Is it possible to resize photos during upload? Nowadays smartphones has larger picture's mpx which means that file weighs more and more, which is reflected in uploading time. I have a sheet where users has to audit some areas on daily basis and take pictures of all nonconformities. Lowest pic has over 6 mpx and upload…
-
Font size inconsistent in Print view across multiple pages
Hi All I have multiple sheets and reports, all the same font & size (Arial 10). When I go to print my reports, some pages show the font clearly, and other pages the quality is compromised/ different font size so my text over different pages looks inconsistent. I saw another thread from 2015 addressing a similar issue but…
-
Start task next day
Hi there, Is there a way to have a task start on the next day, regardless at what time the predecessor finished on the day before? So like a adjustable lag day (or hours) if you want. Thanks!
-
% Rool-Upon another sheet
I have created a construction schedule where i have many lines of of tasks that apply in a mixed format to different subcontractors. Each task has it own % value. I have created another sheet where I have listed the Subcontractors and am trying to roll up the %of every line (associated with a specific subcontractor into a…
-
Use form info in Update Request message
Is there a way to pull a person's name from a sheet and have that auto-fill into the message sent with an update request? For example, I have a sheet that manages group membership. An Update Request is automatically sent to each new group member, and looks something like this: "Hello there! Welcome to our group." I would…
-
Alerts & Reminders
Can we add to "specific date" and include recurring with a certain frequency with alerts and reminders? I'd love to set a reminder to the group to update a field on the 10th of every month, but I don't see a way to do this.
-
Notifications of Changes Made To Cells
Hello Experts I really like the feature of Notifications when I am informed of any changes made to the sheet content by any of our staff whom I have given Editor - Can Not Share permission. However, if the value of a cell is changed, while in the Notification I can see the new value, I do not see what it was before the…
-
Restricting Edit/Delete to comments
I have a sheet where collaborators discuss open issues in comments column. This is great as we can now have the entire discussion around one row-wise subject in its comment box. But a problem is being faced, collaborators are able to edit/delete their previously submitted comments. And that disturbs the discussion. We…