-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
-
Is there a way to lock certain items in an update request
I am wondering if there is a way to lock people from editing in an update request certain fields or if I should not have them in the request at all? Please let me know.
-
Automated Alert & Action Issues
Hello I am trying to solve an issue with a system I have set up for Automated Alerts & Actions. See screenshots below. As you can see by screenshot 3, I have created a trigger column based on date surpassed; once that date is surpassed the cell will change from N to Y. The idea ultimately is when it changes to Y it…
-
Date-time format
When are you developed the possibility to have date-time format ?
-
Linking to another sheet when a certain word is used
I am trying to get 2 sheets to work together. Meaning when I have a certain word or phrase I would like it to link to another sheet. How ever it can only be that word or phrase or nothing else. I need help Thank You
-
Resizing an Image
Is there a way to resize an image that has been inserted into a Dashboard? I am able to increase the size of the Image Widget, but the image is still not large enough and does not fill the widget area. Need to know if I can manually resize the image
-
Non Working Days Feature
I registered all the non working days but it doesn't work on my sheets (see the attachment), is there something wrong? thanks
-
Calculate days remaining
I have an estimated project Finish date of 8/9/16 in a column "Finish". this date is in row 6 and row 161. I have entered a row name TODAY and set the date to current date in the 'Finish" column row 4. I attempted to use the formula: =NETDAYS([Finish]6,[Finish]4) I get no result or error message. Just the formula. What am…
-
Export to Microsoft Project Aplying Filters
Hi All, I have been trying to set up a report and later on export to Microsoft project, although without too much sucess. The idea is to show only parents rows (project deliverables). The report is for a client which cannot see the full project plan. Smartsheet seems to always export the full project plan even when filters…
-
%Complete to be automated
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
