-
move row automation
I have 2 different sheets (Call them A and B) with a formula on A to VLOOKUP items on sheet B, this works correctly. I am using automation to move a row based on completed items onto a separate archive sheets (A archive & B archive). When the cells move the formulas now result in INVALID because the Vlookup original…
-
How can I limit the numbers, in a curve?
Hi, When I am using a chart widget in my dashboard, I need to limit the numbers. e.g. I am making a progress chart, obviously, it is something between 0-100%. But my x-axis shows more, for instance it shows 0-120%. It is ridiculous to show a progress bar chart off %0-%120! How can I limit that?
-
Are form capabilities dependent on licensing?
My colleagues and I are trying to add a file upload field to our form, but the field will not show up when we open the form. We're not sure if this is a temporary bug or if this is because this capability isn't available to us. Any information would be greatly appreciated!
-
Conditional formatting with AND not working as expected
I've created a conditional format using and that states if the date in a column is in the next three days, and the column next to it isn't yet filled, make the cell yellow: As you can see below, it's filling in yellow even when that "send to copy editor: actual" is NOT blank: Any recommendations?
-
Formulas in Gantt dates columns
Hello everyone Do you know if there is a way to put formulas in a start or end date column that is used in a Gantt chart ? The only feature I can use is to link cell from another sheet, but that means I need to link cells for each task in my gantt planning and it will take so much time.. Thank you for your help, Corentin
-
Smartsheet proof function and internet explorer
Hi, I am looking at implementing the proof function in our workspace, however, when viewing a proof in Internet explorer, the zoom and download buttons are covered by the comment pane, is there anything I can do to rectify this?
-
Get the URL of a file attached to a row
Is there a way to get the URL of a file that is attached to a row? By way of example, if an arbitrary PDF file is attached, what is the url that results in previewing the file in a browser tab? In general this seems to be an https://s3.amazonaws.com/ storage location. For Arbitrary file.pdf in the image below (this link…
-
Include Sheet link in an Update Request
I would like to include a link to the smartsheet in my update request workflow, but I cant see how to do it. The help text seems to indicate that the sheet link will be included in the message/update form, but it is not. See screenshots
-
Forms, field logic
I want to set up a field with a yes/no answer and with the following logic: if answered "yes" then show the fields d,f,g (i want these as required fields); and if the answer is "no", show the same fields d,f,g but as optional to answer. So the same fields are showed regardless of the answer, but depending on the answer the…
-
Reconciling across two sheets
Hi everyone. We have 2 sheets that we're using for employee covid health verifications. Sheet 1 is completed by the managers and shows whether an employee is expected to be on site on a given day. Rows are employee names, columns are dates with multi-select choice of site 1, site 2, remote, or unavailable (they can…