-
Getting RowID in a sheet?
Is there a way to get the rowid for a different row for a comment. I have a schedule with a delay of 3d because of something external to the project. In the Predecesor column I have 23FS+3d because of the delay after completing the task on row 23. I would like a comment ="This is delayed because of (reason) after…
-
Setting date ranges with start-date to start-date and end-date to end-date dependencies
I have a project where I am setting a range of production dates and want the sheet to auto-update if I update that there is slippage in the timeline to see how far out things push. It is easy to schedule dependencies on the front end. For example - if I have items: 1. PO to readiness of raw materials is 2 weeks from the PO…
-
New Smartsheet Improvements!
Check out our release notes page for all the details on the newest Smartsheet improvements, including email aliases, new formulas, API update and more!
-
SUMIFS Function with Multiple Column Sum Range
I want to sum values over a two column range using multiple criteria but when I include more than one column in the sum range I get a #MISSING OR INVALID PARAMETERS error message. When I back off the sum range to a single column it works fine. Is the sum range in the SUMIFS function restricted to a single column?
-
Auto assign helpdesk queries
Hi, I have set up a webform to collate helpdesk queries. Every query is one of 6 types (one of the fields on the webform is a drop down to select the type of query. I would like to automatically assign one of four people to handle each query based on which of the 6 types the query is regarding (there is a mapping of type…
-
Date based formula problem
Hi there Can anyone help me with the following formula please? I've published a form which we use for collecting 'hours spent' on each project per day of week (based on a 'week commencing' field). I alreday have a report which then pulls out the time spent based on 'individual' and 'project' but I can't get the 'by week…
-
Trying to build a report, is it possible?
I'm trying to build a report from our company sales pipeline. Our pipeline has 7 sales stages. I'd like a report showing the percentage of our sales teams success progressing prospects from stage 3 or 4 to stage 5 (closed). At this point, I'm not sure how I need to approcae this report and build it. Would appreciate some…
-
Formula to calculate week number or week commencing date
I have a column of dates in a smartsheet, and wish to insert a formula into another column what will tell me either the weeknumber (e.g. Excel WEEKNUM formula) or the weekcommencing date. Does anybody have any suggestions how to acheive this?
-
Formulas Dissappear
Is there a way to keep the formulas from dissappearing? I have a formula set to check if the checkbox is checked but if the checkbox is checked independently from the main checkbox then the formula seems to dissappear. Also, is there a way to view the form as another type of user, ie...viewer, or editor? Thanks YouTube of…
-
Autofill Formula to Pre-Existing Row
On a pre-existing row of data, I want to have a formula autofill when I input new data., i.e. when an escrow closes for a client. In Excel I would simply pre-populate the column by stuffing the formula below into row 1 and then dragging down to row 2,000 then locking the column. Can I do something similar in Smartsheet?…
